Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Karthick30
Creator
Creator
‎2022-05-19 05:50 AM

Zero values in Line Chart

Hi,

I have a Line Chart which has Dimension ( Master month ) and 4 measures. Out of 4 , two measures has data from past 2 years(Masteryear) and 2 measures has data from May 2022. when i add the condition for one of that measure as "if(MasterMonth>=Num(month(today())), Count({<MasterYear={'2022'}>}Account) )". its working fine for current year(2022). but when i apply filter for previous year(2021) , I am seeing 0 values from May2021 to Dec 2021(screenshot below). Is there any way to supress this zero's. Tried unchecked Suppress Zero values in Data Handling section.

Karthick30_0-1652953408776.png

 

Labels (1)
Labels
264 Views
0 Likes
0 Replies