Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

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

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'

2 Replies

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

You may uncheck "Suppress zero value" checkbox

MVP
MVP

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

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'

Community Browser