topic Re: Set Analysis Question to ignore selection in QlikView

Set Analysis Question to ignore selection

Wed, 15 Jan 2014 12:33:10 GMT

I have this expression, but i also would like to ignore [Application Name] selection if user makes from its seleciton box.

trid if condition for count but does not seem to be working.

Count({< [Application Name]=, [Application Name] = {"=count(DISTINCT [Authenticated user]) >5"}>}DISTINCT [Authenticated user] ))

Message was edited by: Faisal Mehmood I have attached examplt,,which does not work

Re: Set Analysis Question to ignore selection

nilesh_gangurde — Wed, 15 Jan 2014 12:34:39 GMT

Try This.

Count({< [Application Name]=, [Application Name] = {"=count( {<[Application Name]=>} DISTINCT [Authenticated user]) >5"}>}DISTINCT [Authenticated user] ))

-Nilesh

Re: Set Analysis Question to ignore selection

danieloberbilli — Wed, 15 Jan 2014 12:35:51 GMT

Delete the first modifier : [Application Name]=,
as you dont need this - the last modifier will do the job

Re: Set Analysis Question to ignore selection

Clever_Anjos — Wed, 15 Jan 2014 12:38:05 GMT

You´re setting two conditions to same field.

Which one you want? If only ignore selections

Count(DISTINCT {< [Application Name]=>}[Authenticated user] )

Re: Set Analysis Question to ignore selection

kiranmanoharrode — Wed, 15 Jan 2014 12:38:09 GMT

Try this............

=Count(DISTINCT {< [Application Name]=>}[Authenticated user] )

Regards
Kiran Rode

+91 8976977897

Re: Set Analysis Question to ignore selection

Wed, 15 Jan 2014 12:57:29 GMT

Hi Nilesh,

should i remove first [Application Name]=, as shown below.

Count({<[Application Name] = {"=count( {<[Application Name]=>} DISTINCT [Authenticated user]) >5"}>}DISTINCT [Authenticated user] ))

Re: Set Analysis Question to ignore selection

Wed, 15 Jan 2014 12:58:16 GMT

I want Authenticated user > 5 and i have selction filed Authneticated user and i dont want tihs to filter my chart

Re: Set Analysis Question to ignore selection

nilesh_gangurde — Wed, 15 Jan 2014 12:59:45 GMT

This will also work. you can remove the first [Application Name]=,

both conditions will Work.

If not then you can se the below expression:

Count({<[Application Name] = {"$(=count( {<[Application Name]=>} DISTINCT [Authenticated user])) >5"}>}DISTINCT[Authenticated user] ))

-Nilesh

Re: Set Analysis Question to ignore selection

Wed, 15 Jan 2014 13:03:41 GMT

try:

if(count(distinct [Authenticated user]) => 5, Count({< [Application Name]=>} [Authenticated user])

Re: Set Analysis Question to ignore selection

Clever_Anjos — Wed, 15 Jan 2014 13:07:45 GMT

Count({<[Application Name] = P({"=count(DISTINCT [Authenticated user]) >5"})>}DISTINCT [Authenticated user] ))

Re: Set Analysis Question to ignore selection

Wed, 15 Jan 2014 15:13:00 GMT

Hi Nilesh,, I did not work ,so attachign example where i was both conditions to work

Re: Set Analysis Question to ignore selection

Wed, 15 Jan 2014 15:13:52 GMT

Please see attached file,,, I need to make sure that applicatin selectiopn does not affect chart.

Re: Re: Set Analysis Question to ignore selection

nilesh_gangurde — Wed, 15 Jan 2014 15:54:29 GMT

Please find attachment

its working.

Re: Re: Set Analysis Question to ignore selection

Wed, 15 Jan 2014 16:57:48 GMT

Thanks ,, it seems i had to do to orther expression as well . so expression with in expression worked.... Can you please simply for me how actualy it works ,,