Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Qlik Sense pivot & dimension

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:

JanuaryFeb
RepActual SalesPlanActual SalesPlan
Joe100110
Sam5050
David2030

My table in Oracle db is structured this way:

repmonthactualplan
JoeJan100110
JoeFeb
JoeMar
SamJan
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!!

3 Replies
Not applicable

Re: Qlik Sense pivot & dimension

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:

versionrepmonthamount
actualJoeJan100
planJoeJan110
JoeFeb
SamMar
Jan
Feb
Mar

If you structure it like above, you will be able to use JS Pivot table.

Thanks!

thoshino
New Contributor II

Re: Qlik Sense pivot & dimension

Why don't you try to use the "Qlik Branch" ?

Maybe there is a sample Extension of  pivot table.

Qlik Branch

Not applicable

Re: Qlik Sense pivot & dimension

I did find the pivot table at Qlik Branch but cannot modify it.

Thank you!