topic Re: All values presentation in QlikView

All values presentation

Sat, 14 Jun 2014 18:49:05 GMT

Hi there,

i want in the attached application to have a table which will show the values for the selected day and 7 days before. Everything works fine when the dates have data but the day is missing when there are no although i have clear the Suppress Zero values flag. Any ideas?

Re: All values presentation

swuehl — Sat, 14 Jun 2014 19:11:43 GMT

That's because you limit your data in your set expression also to certain values of CUST_BUS_STATUS_ID, so your working set only contains TempDates that are contained in table Table.

You can work around this by using an if-statement instead of the set expression for CUST_BUS_STATUS_ID, or remodel your fact table that it contains all combinations of TempDates and CUST_BUS_STATUS_ID.

Re: Re: All values presentation

swuehl — Sat, 14 Jun 2014 21:19:39 GMT

There is another solution with a hidden expression that enables access to all dates.

Re: All values presentation

Sun, 15 Jun 2014 08:29:50 GMT

Hi swuehl,

thank you for your both correct solutions, do you suggest to work with one of them for better performance? If yes, which one? The second?

Regards,

Helen

Re: All values presentation

swuehl — Sun, 15 Jun 2014 12:48:07 GMT

The solution with the if() statement should work in all charts, while the one with the hidden expression probably won't work in all charts and settings.

From a performance point of view, an if() statement will perform worse in most cases (even with the additional hidden expression), but it's depending on your data if this is really the case in your setting and if it does really matter).

So it's up to your setting. Just give it a try.