topic Not reflecting in QlikView

Not reflecting

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Not reflecting

sunny_talwar — Wed, 24 Jan 2018 13:33:44 GMT

Try this

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

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

Re: Not reflecting

Anil_Babu_Samineni — Wed, 24 Jan 2018 13:34:34 GMT

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

Re: Not reflecting

soniasweety — Wed, 24 Jan 2018 13:39:16 GMT

not working giving 0 s

Re: Not reflecting

soniasweety — Wed, 24 Jan 2018 13:39:55 GMT

chart is showing in and ex data in two lines

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

Re: Not reflecting

sunny_talwar — Wed, 24 Jan 2018 13:41:14 GMT

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

Re: Not reflecting

soniasweety — Wed, 24 Jan 2018 13:46:27 GMT

sorry its working

but when I select in Ex values showing 0

I saw that

Re: Not reflecting

sunny_talwar — Wed, 24 Jan 2018 13:48:53 GMT

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?

Re: Not reflecting

soniasweety — Wed, 24 Jan 2018 16:56:20 GMT

is there any way to hide the other line?

Re: Not reflecting

sunny_talwar — Wed, 24 Jan 2018 16:57:36 GMT

What other line?

Re: Not reflecting

soniasweety — Wed, 24 Jan 2018 17:00:57 GMT

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

so I want to hide zero line

Re: Not reflecting

sunny_talwar — Wed, 24 Jan 2018 17:03:14 GMT

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])

Re: Not reflecting

soniasweety — Wed, 24 Jan 2018 17:05:23 GMT

okay thanks sunny