topic Re: how to write a MTD set analysis. in QlikView

how to write a MTD set analysis.

jim_chan — Wed, 24 Oct 2018 02:22:52 GMT

Hi guys,

i have a MTD set analysis as below:

Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"}>} Sales)

my scenario.

1) When i did not select anything - it does shows me the MTD sum sales.

2) But when i select a report_date selection: for exmaple the report_date is 22/10/2018. Then my MTD will turn to 0. 0 value.

So how can i have a MTD that when i select a report_date , it can still show the sum sales of the report_date 22/10/2018 ?

Please help guys.

Rgds

Jim Chan

andrey_krylov — Wed, 24 Oct 2018 04:00:56 GMT

Hi Jim. Try to add the report_date to set analysis

Sum({<Year=, Month=, Quarter=, Week=, DateField=, report_date=, DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"}>} Sales)

Anonymous — Wed, 24 Oct 2018 04:16:12 GMT

Try this may work

Sum({<Year=,Month={">=$(=Floor(MonthStart(DateNum)))"}>}Sales)

Thanks

jim_chan — Wed, 24 Oct 2018 05:00:19 GMT

andrey,

if i have decided to put in the report_date= , does it ignore the report_date selection?

Rgds

Jim

andrey_krylov — Wed, 24 Oct 2018 05:34:48 GMT

Yes, report_date will be ignored.