topic Re: Split the dimension in qliksense in App Development

Split the dimension in qliksense

Aspiring_Developer — Mon, 01 Aug 2022 11:34:12 GMT

Hi All,

I have to create stack bar chart using below data :-

Dimension 1	=if(match(Brand,'BT','Plusnet','EE'),'BT Group',if(Brand='Total Market','Total Market'))
Dimension 2	Speed by dp v/s tp

Measure 1

Sum({<Brand = {'Total Market'}>}speed volume) / Sum({<Brand = {'Total Market'}>} total speed volume)

Measure 2

Sum({<Brand = {'BT','Plusnet','EE'}>}Speed Volume)

For measure 2 , I want to show the stack bar chart on the below logic :-

Stack bar = BT group

Measure - Sum of speed volume

For example= speed volume sum is 100

I wish to show the breakdown of my measure with respect to speed volumes (Copper, SF1, >SF2) like below :-

Can anyone please help ?

Thanks in advance

Aspiring_Developer — Mon, 01 Aug 2022 14:29:53 GMT

Hello,

Can anyone please help me on this ?

Thanks

vidyutverma — Wed, 03 Aug 2022 15:19:40 GMT

Are you sure you need Two dimensions and Two Measures? As per your example you have only Two dimensions and One Measure. Is thould be possible.

Aspiring_Developer — Thu, 04 Aug 2022 08:09:11 GMT

Yes, I need two dimensions and two measures.

Thanks