Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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