Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
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))