topic Re: Set Analysis table that works show no data in a specific case in QlikView

Set Analysis table that works show no data in a specific case

Mon, 07 Apr 2014 08:34:32 GMT

Hi All,

I have the following issue:

I have a set analysis tables that shows the installs sum of the last week.

My expression is:

sum({<is7daysDate={'1'}, isYesterdayDate=> } installviewAction)

this Usually works great, except for the following case:

In a specific partner I have no transactions for the dates 4/4/2014, 5/4/2014

When filtering by this partner and choosing the "is7daysDate" you see that these dates are missing from the listbox of dates.

In this case the graph shows no data and I see "no data to display".

Is there any way to make my graph show the dates that he does have data in?

And show 0 installs if there is no data?

Thank you,

Ella

Re: Set Analysis table that works show no data in a specific case

alexandros17 — Mon, 07 Apr 2014 08:36:21 GMT

You may uncheck "Suppress zero value" checkbox

Re: Set Analysis table that works show no data in a specific case

tresB — Mon, 07 Apr 2014 08:37:32 GMT

Try:

Check 'Show All Values' in the dimension tab and enable 'Zero on Bars' in the presentation tab of the chart and uncheck 'Supress Zero Values'