Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ron1
Partner - Creator
Partner - Creator

Dynamic Measure For Pivot table

I want to apply dynamic measure in Pivot table.

As an example , below is my input table. Also below input table I want to see the the data in Pivot table and output should be as below

InPut:

Business TypeSubTypeSalesType
DigitalCloud100LOU
DigitalCloud10IOU
DigitalIT100LOU
DigitalIT10IOU
DigitalAI100LOU
DigitalAI10IOU
DigitalHI100LOU
DigitalHI10IOU
LifeSciencesREG100LOU
LifeSciencesREG10IOU
LifeSciencesBYU100LOU
LifeSciencesBYU10IOU
LifeSciencesCUY100LOU
LifeSciencesCUY10IOU

 

OutPut:

The Sales Value will be shown for type 'LOU' across Business Type in Pivot. Please see the required output in attachment

 

5 Replies
JordyWegman
Partner - Master
Partner - Master

Hi Ron,

Get the following measure:

Sum({$< Type = {'LOU'}>}Sales)

Jordy

Climber 

Work smarter, not harder
Ron1
Partner - Creator
Partner - Creator
Author

Hi Jordy,
Please check the output attachement once. For Business Type -> Sum should be for Type(LOU)
But for Subtype in the same Pivot sum of sales will be for both (Type: LOU and IOU)
Just refer the output attachment once..
JordyWegman
Partner - Master
Partner - Master

In your example I only see type LOU and not IOU. But it's not possible to have two measures in one column. You should create two measures if you want to achieve this.

Jordy

Climber

Work smarter, not harder
Ron1
Partner - Creator
Partner - Creator
Author

Inside input table, you can see IOU value in 4th Column.
Business Type SubType Sales Type
Digital Cloud 100 LOU
Digital Cloud 10 IOU
Digital IT 100 LOU
Digital IT 10 IOU
Digital AI 100 LOU
Digital AI 10 IOU
Digital HI 100 LOU
Digital HI 10 IOU
LifeSciences REG 100 LOU
LifeSciences REG 10 IOU
LifeSciences BYU 100 LOU
LifeSciences BYU 10 IOU
LifeSciences CUY 100 LOU
LifeSciences CUY 10 IOU
However it is possible to generate the output using a single measured field. (THis is a bit complex but possible)(THe exact output figure is possible to generate)
JordyWegman
Partner - Master
Partner - Master

This isn't possible because you can't first include and then exclude dimensions.

2019-06-04 13_14_24-Server 13 - 10.213.151.146.png

Jordy
Climber

Work smarter, not harder