Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mohiahmed
Contributor III
Contributor III

Expression in Pivot - help

Hello all

I am tying to calculate <=1 day, 2 days and > 2 days as percentage.

from this

JanFebMar
<=1 day152034
2 days81612
> 2 days1610
Total244256

To show this

 

JanFebMar
<=1 day63%48%61%
2 days33%38%21%
> 2 days4%14%18%
Total100%100%100%

Any help would be appreciated.

Regards

Mohi

0 Replies