Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello -
I am wondering if there is any extension for pivot tables in qlik sense? I added JSPivot extension I found int he forms but that can only show one measure at the time. I am looking for something like this:
January | Feb | |||
Rep | Actual Sales | Plan | Actual Sales | Plan |
Joe | 100 | 110 | ||
Sam | 50 | 50 | ||
David | 20 | 30 |
My table in Oracle db is structured this way:
rep | month | actual | plan |
Joe | Jan | 100 | 110 |
Joe | Feb | ||
Joe | Mar | ||
Sam | Jan | ||
Feb | |||
Mar |
With the JSPivot I am not able to have two measures in a column and also unable to next columns.
Please let me know if there is anything else out there to use for pivoting data.
Thanks!!
Hi -
It depends on your table structure. I have oracle DB table but rather than having two columns in the table for actual and plan, I have one column and show version_id which will tell me if it is actual or plan. So your structure would look like this:
version | rep | month | amount | |
actual | Joe | Jan | 100 | |
plan | Joe | Jan | 110 | |
Joe | Feb | |||
Sam | Mar | |||
Jan | ||||
Feb | ||||
Mar | ||||
If you structure it like above, you will be able to use JS Pivot table.
Thanks!
Why don't you try to use the "Qlik Branch" ?
Maybe there is a sample Extension of pivot table.
I did find the pivot table at Qlik Branch but cannot modify it.
Thank you!