topic Re: Applying set analysis in QlikView

Applying set analysis

balanandam — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have attached my sample app here. In that we've 2 Charts

1. Transactions by Product

2. Transactions by Device

first one to be static since applied set analysis. But when I click any bar on first chart, second Char must be filtered accordingly. Fine every thing ok, But problem with %'s within second Chart.

But I want this should not be change, should give actual ones.

I know set analysis must be applied, But I don't have much knowledge.

Pls. advice.

Br, Balanandam

Re: Applying set analysis

sunny_talwar — Thu, 01 Feb 2018 12:50:10 GMT

Use this expression and uncheck 'Relative'

sum(Unique_IMEI_Count)/sum(TOTAL {<ProductName>} Unique_IMEI_Count)

Re: Applying set analysis

balanandam — Thu, 01 Feb 2018 13:44:20 GMT

Thanks! sunny.

I've another concern here, that I need % besides of the count for both charts. !for ex:

2,088,674 (44.81%)

I tired concatenating two expressions, didn't get solved and my idea looked so silly. Can you advise here too!

Br, Balanandam

Re: Applying set analysis

sunny_talwar — Thu, 01 Feb 2018 13:49:41 GMT

Like this?

Use this expression

Dual(Num(Sum(Unique_IMEI_Count), '#,##0.') & ' (' & Num(sum(Unique_IMEI_Count)/sum(TOTAL {<ProductName>} Unique_IMEI_Count) , '##.##%') & ')', Sum(Unique_IMEI_Count))

and make sure to select 'Expression Default' on the Numbers tab of chart properties

Re: Applying set analysis

balanandam — Thu, 01 Feb 2018 15:51:20 GMT

Thank you Sunny.

I've confused a lot with the expression but I'll dig myself into this and the DUAL() function.

Br, Balanandam