topic Re: Max(date) in set analysis in QlikView

Max(date) in set analysis

Thu, 19 Jan 2012 11:12:58 GMT

Hi all,

I have a doubt about how QlikView calculates Set Analysis expressions in charts.

I have a chart where I wan’t to see the results for the last day of a given period. So I’m restricting my selection to that date by using this expression:

FULL_DATE ={"=(Date(Max(FULL_DATE)))"}

This Works fine if I’m seeing the chart at a month level, however when I see this at year level, the value I got is not the value of the last day of year, but the sum of the values of the last day of that year months.

Shouldn’t my full_date be restricted to one value per year only, when I’m looking at a year level?

Thanks in advance.

Best regards

Re: Max(date) in set analysis

lironbaram — Thu, 19 Jan 2012 11:33:26 GMT

hei if fulldate is date field like 31/12/2011

it shuold work attach is an example

Re: Max(date) in set analysis

Thu, 19 Jan 2012 11:48:07 GMT

But if you have a chart, it only sows the last month of the year. I need to show all the months, with the value for the last day of each month. And then when you see at year level, you should see only the value for the last day of the year.

See example attached.

Thanks.

Re: Max(date) in set analysis

lironbaram — Thu, 19 Jan 2012 12:16:31 GMT

hei check this example

in your case you cant use set analysis because set anlysis make the selection outside the chart so even if you select month as dimension

the set analyseis will select only the last avilable date