Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Not reflecting

hi all,

I have a chart when I select  filter it is not reflecting

used dimension: =aggr(if(JNum>=$(vMTrend),MonthName([JDate])),[JDate])

measure1: count({<[FStatus]={'Joined'},[In/Ex]={"In"}>}[ID])

meausre2: count({<[FStatus]={'Joined'},[In/Ex]={"ex"}>}[ID])

selected  In/Ex  filter  the chart is not reflecting

Labels (1)
12 Replies
soniasweety
Master
Master
Author

now one value selecting that chart displaying with two lines  one with values one with zero line

so I want to hide zero line

sunny_talwar

Why don't you just use a pivot table and use In/Ex as your pivoted dimension? and a single expression like this

count({<[FStatus]={'Joined'}>}[ID])

soniasweety
Master
Master
Author

okay thanks sunny