Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

1 Solution

Accepted Solutions
Highlighted

Try this

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

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

View solution in original post

12 Replies
Highlighted

Try this

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

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

View solution in original post

Highlighted

In case, If you want to know the filter based ID's then why you are using Set analysis for [In/Ex] ??

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)
Highlighted
Master
Master

not working giving 0 s

Highlighted
Master
Master

chart is showing in and ex data in two lines

and if I use that also  filter means it should work na

Highlighted

So, your original expressions worked, but by adding an asterisk the expression become 0? Really or are you kidding me

Highlighted
Master
Master

sorry its working

but when I select in  Ex values showing 0

I saw that

Highlighted

So, that's the good thing right? You wanted your expression to react to In/Ex field selections, right? Now it is doing that... what is the issue?

Highlighted
Master
Master

is there any way to hide the other line?

Highlighted

What other line?