topic Re: Less than or equal to in set analysis in QlikView

Less than or equal to in set analysis

zagzebski — Fri, 11 Jul 2014 15:23:08 GMT

This should be pretty simple but for some reason not working as expected.

I have an expression that uses the following set:

Month={"<=$(=max(Month))"}

The Month fields is : 201401, 201402, 201403,,,etc.

When I select (for example) 201403 I would expect that my expression would sum on 201401, 201402, and 201403 because the expression should take less than or equal to the max selected value. However it only uses 201403.

Is this because the Month field is a text field? If so how could I rewrite to make this work?

Thanks in advance...

Re: Less than or equal to in set analysis

MK_QSL — Fri, 11 Jul 2014 15:27:30 GMT

Month = {'<=$(=Max(Month))'}

try

Month = {'<=$(==Date(Max(Month),'YYYYMM'))'}

Re: Less than or equal to in set analysis

zagzebski — Fri, 11 Jul 2014 15:31:51 GMT

Thanks for the response.

Unfortunately it is still only bringing back the selected month, not the prior months.

Re: Less than or equal to in set analysis

MK_QSL — Fri, 11 Jul 2014 15:35:49 GMT

Month = {'<=$(=Date(Max(Month),'YYYYMM'))'}

Re: Less than or equal to in set analysis

alexandros17 — Fri, 11 Jul 2014 15:38:15 GMT

Are you sure that values computed is present for previous months?

Re: Less than or equal to in set analysis

zagzebski — Fri, 11 Jul 2014 15:41:09 GMT

Yes there are.

Re: Less than or equal to in set analysis

alexandros17 — Fri, 11 Jul 2014 15:45:13 GMT

Syntax seems correct, but anyway try this ...

Sum({$ <Month={'<0201404'}>} myField)

that is fix a month and paste in the set analysis as showed