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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding a new dimension to pivot table

Hi,

Currently, I have the following data presented in listbox in qlikview as follows:

Where complexity is being defined as an expression such that: simple: timetaken<11, average: 11 <timetaken<20, complex >20

complexitycategorytimetaken
simpleA8
complexB30
averageC17
simple D9
complexE25

May I know if there is anyway to put this into a pivot table such that the first dimension will be complexity, followed by category, and the expression will be timetaken?

I tried taking the same expression for complexity and copy into the calculated dimension in pivot table. but it shows calculation error.

P.S: Please do not attach qlikview files, I cant seem to download and view it on my qlikview.

Thanks

10 Replies
Not applicable
Author

It says calculation error when I were to do step 4.

my  original expression is

if((interval(if(turnaroundtime>=0,Round(Avg(turnaroundtime)))/86400,'d:hh:mm:ss'))<1,'Simple',
if((interval(if(turnaroundtime>=0,Round(Avg(turnaroundtime)))/86400,'d:hh:mm:ss'))>=1 and (interval(if(turnaroundtime>=0,Round(Avg(turnaroundtime)))/86400,'d:hh:mm:ss'))<3,'Moderate',
if((interval(if(turnaroundtime>=0,Round(Avg(turnaroundtime)))/86400,'d:hh:mm:ss'))>=3 and (interval(if(turnaroundtime>=0,Round(Avg(turnaroundtime)))/86400,'d:hh:mm:ss'))<10,'Advanced','Complex')))

It surfaced calculation error.