Selection should not effect ?

[gauravgg]

Hi

I have the following two expression

count(distinct{<Part={"=count(Part)=Max(TOTAL Aggr(Count(Part),Part))"}>}Part)

count(Aggr(if(Count(DISTINCT [FG Desc]&PLANT) =1,Part),Part))

I dont want the effect of selection for a perticular field on that expressions

can anyone help me

thanks in Advance

[shraddha_g]

If possible share sample app

[its_anandrjs]

Then try to add all dimensions that you would not to be selected this way

count({1} distinct{<Part={"=count(Part)=Max(TOTAL Aggr(Count(Part),Part))"},Field1=,Field2=,Field3=,.....>}Part)

count({1} Aggr(if(Count(DISTINCT [FG Desc]&PLANT) =1,Part),Part))

Or

count({1} distinct{<Part={"=count(Part)=Max(TOTAL Aggr({1} Count(Part),Part))"}>}Part)

count({1} Aggr({1}  if(Count(DISTINCT [FG Desc]&PLANT) =1,Part),Part))

[Kushal_Chawda]

try this

count(distinct{1<Part={"=count({1}Part)=Max({1} TOTAL Aggr(Count({1}Part),Part))"}>}Part)

count({1}Aggr(if(Count({1}DISTINCT [FG Desc]&PLANT) =1,Part),Part))

[gauravgg]

not working

[Kushal_Chawda]

Both expression not working?

[its_anandrjs]

It is strange both the expression not working please read this manual from the Qlikview Help very helpful to you to understand the SET analysis in the qlikview.

Please read complete manual.

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/SetAnalysis/set-a...

[sunny_talwar]

For 2, you can try this

Count({1} Aggr(If(Count({1} DISTINCT [FG Desc] & PLANT) = 1, Only({1} Part)), Part))

[gauravgg]

Hi Sunny

It is not working

[sunny_talwar]

‌All you have been saying ti everyone is that it is not working. But you never mention that what exactly is not working. Does it error out? Does it work without selection, but with selection it changes? I mean all you have shown is an expression, but how its used is a mystry. Please provide more details on why it isn't working or share a sample where we can see what is going on.

[gauravgg]

hi sunny

I have a bar chart in qliksense which counts number of common parts and  number of unique parts  on the fly

count(distinct{<Part={"=count(Part)=Max(TOTAL Aggr(Count(Part),Part))"}>}Part)

count(Aggr(if(Count(DISTINCT [FG Desc]&PLANT) =1,Part),Part))

when i made changes  according to all the suggestion above the count of the bar chart changes

even if i dont select any filter

there are 2 fields in data model ,on selection in that field the count should not change in bar graph

I cannot share app because it is on server,i do not have rights.