Set Analysis Question to ignore selection

[#1]

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

[nilesh_gangurde]

Try This.

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

-Nilesh

[danieloberbilli]

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

[Clever_Anjos]

You´re setting two conditions to same field.

Which one you want? If only ignore selections

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

[kiranmanoharrode]

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

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

Regards
Kiran Rode

+91 8976977897

[#6]

Hi Nilesh,

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

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

[#7]

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

[nilesh_gangurde]

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

[#9]

try:

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

[Clever_Anjos]

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