topic Qlik Sense pivot & dimension in App Development

Qlik Sense pivot & dimension

Thu, 11 Dec 2014 21:54:48 GMT

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!!

Re: Qlik Sense pivot & dimension

Sat, 13 Dec 2014 22:15:15 GMT

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!

Re: Qlik Sense pivot & dimension

thoshino — Mon, 15 Dec 2014 04:10:19 GMT

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

Maybe there is a sample Extension of pivot table.

Qlik Branch

Re: Qlik Sense pivot & dimension

Tue, 16 Dec 2014 00:41:43 GMT

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

Thank you!