Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Analysis in Date Dimension

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!

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Set Analysis in Date Dimension

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')

2 Replies

Set Analysis in Date Dimension

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

mov
Esteemed Contributor III

Set Analysis in Date Dimension

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')

Community Browser