topic Re: Help on Set analaysis Month Condition in QlikView

Help on Set analaysis Month Condition

Tue, 27 Aug 2013 07:29:58 GMT

HI Everyone,

I am trying to create a set analysis condition .

I need Sum FCTotal 1 where the FcMonthsid and Year-Month Number Matches.

sum({$<[FC Month Sid]={"$(=[Year-Month Number])"}>}[FcTotal1])

When i refresh the dashboard for one month the formula gives the result. When i refresh the dashboard for multiple months it is not giving any value.Please help me on achiving this.Thanks in Advance

Re: Help on Set analaysis Month Condition

vikasmahajan — Tue, 27 Aug 2013 07:40:16 GMT

USE THIS EXPRESSION BY DEFAULT THIS WILL SHOW YTD AND WHEN U SELECT MONTH THEN MONHTS ALSO

SUM({$<FiscalYear={$(=max(FiscalYear))}>} [FcTotal1] )

vikas

Re: Help on Set analaysis Month Condition

Tue, 27 Aug 2013 07:40:38 GMT

Hi Krishnan,

I'd say this is working as intended for now. This set analysis will only work if you have oneYear-Month selected otherwise how does it know what value of [FC Month Sid] to compare it to. If you want it to work for multiple month selections you need to decide what it's function will be.

i.e. do you want it to sum up where [FC Month Sid] = the maximum value of Year-Month possible or do you want it to sum up where [FC Month Sid] <= the max value or Year-Month?

Andy

for the first option to work you will need:

=Sum({$<[FC Month Sid] = {"=$(=Max([Year-Month Number]))"}>}[FcTotal1])

and for the second

=Sum({$<[FC Month Sid] = {"<=$(=Max([Year-Month Number]))"}>}[FcTotal1])

When no selections are made in Year-Month it will default to the max value in your data set.