Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Specialist
Specialist

Split the dimension in qliksense

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 

BT group bar  100
Copper 20%
SF1 60%
>SF2 20%

 

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

Aspiring_Developer_0-1659353607457.png

 

Can anyone please help ?

Thanks in advance 

Labels (1)
3 Replies
Aspiring_Developer
Specialist
Specialist
Author

Hello,

Can anyone please help me on this ?

Thanks

vidyutverma
Partner - Contributor III
Partner - Contributor III

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
Specialist
Specialist
Author

Yes,  I need two dimensions and two measures.

Thanks