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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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