{"id":28,"date":"2025-09-08T13:44:34","date_gmt":"2025-09-08T05:44:34","guid":{"rendered":"https:\/\/www.terryche.com\/?p=28"},"modified":"2025-09-08T16:01:26","modified_gmt":"2025-09-08T08:01:26","slug":"qlik-sense-%e4%b8%ad%e5%a6%82%e4%bd%95%e9%80%89%e6%8b%a9%e4%bb%8a%e5%b9%b4%e7%9a%84%e6%97%b6%e9%97%b4%ef%bc%8cmeasure-%e6%98%be%e7%a4%ba%e5%8e%bb%e5%b9%b4%e7%9a%84%e6%95%b0%e5%ad%97","status":"publish","type":"post","link":"https:\/\/www.terryche.com\/?p=28","title":{"rendered":"Qlik Sense \u4e2d\u5982\u4f55\u9009\u62e9\u4eca\u5e74\u7684\u65f6\u95f4\uff0cmeasure \u663e\u793a\u53bb\u5e74\u7684\u6570\u5b57"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u6bd4\u5982\u8fd9\u91cc\u6211\u5728<\/p>\n\n\n<p>[trip_flight_date.autoCalendar.YearMonth]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e2d\u9009\u62e92025-Oct, 2025-Nov\u3002 \u6211\u5374\u8981\u5728Measure \u4e2d\u76f4\u63a5\u663e\u793a2024-Oct, 2024-Nov \u7684\u6570\u5b57\u3002<\/p>\n\n\n<p>Sum(<br \/>\n  {<\n    [trip_flight_date.autoCalendar.YearMonth] = \n      {$(=\n  Concat(\n    DISTINCT \n      chr(39)&#038;Date(\n        AddMonths(\n          Date#([trip_flight_date.autoCalendar.YearMonth],'YYYY-MMM'),\n          -12\n        ),\n        'YYYY-MMM'\n      )&#038;chr(39),\n    ','\n  )\n  \n      )}\n  >}<br \/>\n  od_pax<br \/>\n)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6700\u4e3b\u8981\u7684\u662f\u4ee5\u4e0b\u8fd9\u6bb5\u3002<\/p>\n\n\n<p>  Concat(<br \/>\n    DISTINCT<br \/>\n      chr(39)&#038;Date(<br \/>\n        AddMonths(<br \/>\n          Date#([trip_flight_date.autoCalendar.YearMonth],&#8217;YYYY-MMM&#8217;),<br \/>\n          -12<br \/>\n        ),<br \/>\n        &#8216;YYYY-MMM&#8217;<br \/>\n      )&#038;chr(39),<br \/>\n    &#8216;,&#8217;<br \/>\n  )<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6bd4\u5982\u8fd9\u91cc\u6211\u5728 \u4e2d\u9009\u62e92025-Oct, 2025-Nov\u3002 \u6211\u5374\u8981\u5728Measure \u4e2d\u76f4\u63a5\u663e\u793a2024-Oct [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":25,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[5],"class_list":["post-28","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-workwork","tag-qliksense"],"_links":{"self":[{"href":"https:\/\/www.terryche.com\/index.php?rest_route=\/wp\/v2\/posts\/28","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.terryche.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.terryche.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.terryche.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.terryche.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=28"}],"version-history":[{"count":0,"href":"https:\/\/www.terryche.com\/index.php?rest_route=\/wp\/v2\/posts\/28\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.terryche.com\/index.php?rest_route=\/wp\/v2\/media\/25"}],"wp:attachment":[{"href":"https:\/\/www.terryche.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=28"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.terryche.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=28"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.terryche.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=28"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}