Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
kruel830
New Contributor II

Problem with zeroes when using set analysis

I have created bar chart with dynamic date limits for Nprinting, but I don't know how to hide zero values. Bar chart shows YTD figures for 2018 and 2017 and therefore chart looks stupid as I have used year as dimension, but I don't know what else dimensions I could use. "Include null values"-selection does nothing for this. Any help?

rev.jpg

 

 

3 Replies

Re: Problem with zeroes when using set analysis

Can you please share sample test file to demonstrate the issue?
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kruel830
New Contributor II

Re: Problem with zeroes when using set analysis

Unfortunately I can't, but I can tell expressions I have used:

Dimension: Year

Revenue YTD: Sum({<Date = {'>=$(=YearStart((now())))<=$(=MonthEnd(AddMonths(now(),-1)))'}>} [Sales])
Budgeted: Sum({<Date = {'>=$(=YearStart((now())))<=$(=MonthEnd(AddMonths(now(),-1)))'}>} [BudSales])
Oct 2017: Sum({<Date = {'>=$(=YearStart((now()-395)))<=$(=MonthEnd(AddMonths(now(),-13)))'}>} [Sales])

 

I understand why it displays 2017 and 2018 labels, it is because there is data from 2017 and also from 2018. And some of them are zeroes. e.g. Revenue YTD doesn't have any data from the year 2017. But I want those 3 bars to next to each other, not like those are now.

Re: Problem with zeroes when using set analysis

Sorry
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)