Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
lessassy
Creator
Creator

Create category field with two sub fields

Hello,

I have two measure that i want to put into a pie chart 

SUM({<SS_TYP_MVT_CD = 'Entry', MOT_MVT_CD = {'EMB_TKP'}>}MEASURE1)
SUM({<SS_TYP_MVT_CD = 'Entry', MOT_MVT_CD = {'EMB_AOV'}>}MEASURE1)

 

Basically i want to have displayed the percentage for the two measures.

I want to create one category that incorporate the two measures .

Example :

Category A

=>  SS_TYP_MVT_CD = 'Entry', MOT_MVT_CD = 'EMB_TKP' as Cat1

=> SS_TYP_MVT_CD = 'Entry', MOT_MVT_CD = 'EMB_AOV' as Cat2

 

Basically I want to create a category that have Cat1 and Cat2 as one category so i could display the percentages in the pie chart.

Thanks in advance

 

 

Measure1 percentage = P

Labels (2)
2 Replies
QFabian
Specialist III
Specialist III

Hi @lessassy , i recommend to you, take this to script , like this:

Data:

'Cat1'  as Category,

SUM(MEASURE1)  as Measure

From yoursourcedata

Where

SS_TYP_MVT_CD = 'Entry' and

MOT_MVT_CD = 'EMB_TKP'

Group By [your fields for agrupation];

 

;

Load

'Cat2'  as Category,

SUM(MEASURE1)  as Measure

From yoursourcedata

Where

SS_TYP_MVT_CD = 'Entry', and

MOT_MVT_CD = 'EMB_AOV'

Group By [your fields for agrupation];

 

 

Then creates a chart using the new dimension 'Category'

QFabian
Kushal_Chawda

@lessassy  try below

Create pie chart with below dimension and measure

Dimension:

= valuelist('Cat1','Cat2')

Measure:

=Pick(Match(valuelist('Cat1','Cat2'),'Cat1','Cat2'),
SUM({<SS_TYP_MVT_CD = {'Entry'}, MOT_MVT_CD = {'EMB_TKP'}>}MEASURE1)
SUM({<SS_TYP_MVT_CD = {'Entry'}, MOT_MVT_CD = {'EMB_AOV'}>}MEASURE1))