topic Selection should not effect ? in QlikView

Selection should not effect ?

gauravgg — Fri, 08 Sep 2017 06:22:54 GMT

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

Re: Selection should not effect ?

Anil_Babu_Samineni — Fri, 08 Sep 2017 06:25:39 GMT

Try this?

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

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

Re: Selection should not effect ?

stabben23 — Fri, 08 Sep 2017 06:27:39 GMT

Hi,

then you need to add these Fields in you set analysis, try like this in bold.

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

count({<Field1,Field2,Field3>}Aggr(if(Count(DISTINCT [FG Desc]&PLANT) =1,Part),Part))

Re: Selection should not effect ?

its_anandrjs — Fri, 08 Sep 2017 06:30:53 GMT

Try one of this

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

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

Re: Selection should not effect ?

gauravgg — Fri, 08 Sep 2017 06:37:47 GMT

No ,it is not working

thanks for reply

Re: Selection should not effect ?

gauravgg — Fri, 08 Sep 2017 06:39:08 GMT

No ,it is not working

thanks for reply

Re: Selection should not effect ?

gauravgg — Fri, 08 Sep 2017 06:39:16 GMT

No ,it is not working

thanks for reply

Re: Selection should not effect ?

shraddha_g — Fri, 08 Sep 2017 06:41:57 GMT

Try

count({1} distinct{<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))

Re: Selection should not effect ?

Anil_Babu_Samineni — Fri, 08 Sep 2017 06:48:03 GMT

How about this?

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

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

If not, i would respect to ask share image where you done

Re: Selection should not effect ?

gauravgg — Fri, 08 Sep 2017 06:51:02 GMT

No ,it is not working

Re: Selection should not effect ?

shraddha_g — Fri, 08 Sep 2017 06:52:54 GMT

If possible share sample app

Re: Selection should not effect ?

its_anandrjs — Fri, 08 Sep 2017 06:55:13 GMT

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

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

Re: Selection should not effect ?

Kushal_Chawda — Fri, 08 Sep 2017 06:55:47 GMT

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

Re: Selection should not effect ?

gauravgg — Fri, 08 Sep 2017 06:59:42 GMT

not working

Re: Selection should not effect ?

Kushal_Chawda — Fri, 08 Sep 2017 07:01:52 GMT

Both expression not working?

Re: Selection should not effect ?

its_anandrjs — Fri, 08 Sep 2017 07:19:14 GMT

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-analysis-expressions.…

Re: Selection should not effect ?

sunny_talwar — Sat, 16 Sep 2017 02:55:48 GMT

For 2, you can try this

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

Re: Selection should not effect ?

gauravgg — Sat, 16 Sep 2017 19:19:50 GMT

Hi Sunny

It is not working

Re: Selection should not effect ?

sunny_talwar — Sat, 16 Sep 2017 21:37:34 GMT

‌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.

Re: Selection should not effect ?

gauravgg — Sun, 17 Sep 2017 05:12:35 GMT

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.