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

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
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

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