topic Set Analysis in Date Dimension in QlikView

Set Analysis in Date Dimension

Fri, 07 Oct 2011 23:34:04 GMT

Is it possible to put a set modifier in a date dimension?

i.e. date({$<Step={4}>} Date, 'MM-DD-YY')

An order can go through many steps, but i want all of the order's information to report on the date that step 4 occurs.

My problem occurs when I'm doing a stacked graph comparing the data of each step, so data that occurs on step 5 reports on the date of step 5, not step 4.

Please help!

Set Analysis in Date Dimension

kaushiknsolanki — Sat, 08 Oct 2011 06:26:43 GMT

Hi,

Set Analysis is not possible in date function.

If you can give us full detail of your problem with description and the sample file, that would make it easier for us to understand and solve your problem.

Regards,

Kaushik Solanki

Set Analysis in Date Dimension

Anonymous — Sat, 08 Oct 2011 13:41:59 GMT

Set works only with aggregation functions. Your can use
only({$<Step={4}>} Date)
or, if you have to use formatting
date(only({$<Step={4}>} Date), 'MM-DD-YY')