topic Re: set analysis-comparing 2 fields in QlikView

set analysis-comparing 2 fields

Matsa — Sat, 16 Nov 2024 00:51:45 GMT

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 — Sun, 12 Apr 2020 03:13:36 GMT

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

Matsa — Sun, 12 Apr 2020 09:36:16 GMT

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

Regards,

Matsa

Saravanan_Desingh — Sun, 12 Apr 2020 15:23:14 GMT

Hi,

Can you please try this?

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

Matsa — Tue, 14 Apr 2020 07:28:41 GMT

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

Regards,

Matsa

Saravanan_Desingh — Sun, 19 Apr 2020 15:44:02 GMT

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

Brett_Bleess — Wed, 29 Apr 2020 19:16:09 GMT

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

Regards,
Brett