set analysis-comparing 2 fields

[Matsa]

Hi experts,

I need a help on set analysis.

I want to do set analysis based on camparing 2 fileds .

I need to count ,FILED1 when COUNT1=COUNT2 which is not change with selection.

I wrote this one:

='TOTAL :'&count(distinct{<FILED1={"=COUNT1=COUNT2"}>} FILED1)

would you please guide me how should I correct it.

Thank you in advance.

regards,

Matsa

[Saravanan_Desingh]

Hi, I didn't see any issue with this expression. Please let me know what kind of issue you are facing.

[Matsa]

Hi @Saravanan_Desingh ,it changes based on selection, But I need fixed value for all.

Regards,

Matsa

[Saravanan_Desingh]

Hi,

Can you please try this?

='TOTAL :'&count(distinct{1<FILED1={"=COUNT1=COUNT2"}>} FILED1)

[Matsa]

hi @Saravanan_Desingh ,

it is strange but even with this 1 , it changes based on selection.

Regards,

Matsa

[Saravanan_Desingh]

Please post a sample app. That will help to dissect.

[Brett_Bleess]

I suspect the following Design Blog link may be helpful too:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett