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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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