topic Re: Can someone make this solution more flexible? Calendar issue in QlikView

Can someone make this solution more flexible? Calendar issue

amien — Sat, 10 Sep 2016 11:14:40 GMT

See attachment for an example.

There 3 three selection possibilities for the end user:

1. dims

2. expressions

3. date dimensions (Current Year, last 8 weeks etc)

The dims en expressions work with the normal conditional show as we all know it.

The date are in states. Bases on the date dim selections the expressions are multiplied with a specific flag, which are created in the load script.

This solution make it possible to reduce the number of conditional expressions that should be created. In my real world solution i have like 10 expressions and 10 date selections. So this would mean i have to create (and maintain) 10x10x2 conditional expressions.

The down side is that you can only show the data for the current year, because the flags are set in the load script.

My Question : Does anyone know a solution to make this more flexible? So that it is possible to select a Year or a Year-Week and implement the known "point in time" solution for example, without creating any more condition expressions?

Thanks in advanced

Re: Can someone make this solution more flexible? Calendar issue

sunny_talwar — Sat, 10 Sep 2016 11:32:05 GMT

Are you looking for something like the attached?

Re: Can someone make this solution more flexible? Calendar issue

sunny_talwar — Sat, 10 Sep 2016 11:33:57 GMT

Actuaklly, this seems to be a less complicated expression

Re: Can someone make this solution more flexible? Calendar issue

amien — Sat, 10 Sep 2016 11:37:24 GMT

No, because this is only a FY comparison, i would also like to compare between with these for example : Last 8 weeks, Last 4 weeks, YTD, This week, previous week LY etc. And this should be depended on the Year or Week that is selected. I guess that selection should be in a separate listbox.