Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Naresh1
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
aditya9243
Contributor
Contributor

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