Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Qliksense Pivot table percentage

Hi everyone,

I am taken pivot table in qliksense , in those pivot table dimensions are order_id,items and colum i was taken month and measure i was taken value

in this where party code =1000,2000 i want to show percentages(%)  values for these  two order_ids remaining values i  want  to show numbers only,

can anyone tell me how to write expression for this,

 

Regards,

1 Reply
Highlighted
Contributor
Contributor

If(orderid= '1000' or orderid='2000',
Sum(measure)/sum(total measure),
Sum(measure))