topic Re: Create Super Tab Sub Tab in Pivot table in QlikView

Create Super Tab Sub Tab in Pivot table

eromiyasimon — Wed, 25 Nov 2020 16:16:04 GMT

i want to group expression and dimension under a tab,

attached the screen shot for your reference

Anonymous — Fri, 23 Dec 2016 13:06:10 GMT

Hi eromiya,

To group the expression you can create a dimension with MTH, RQRT and MAT fields. then pivot this to column headers.

Regards!!!

eromiyasimon — Fri, 23 Dec 2016 13:08:22 GMT

could you please give some sample QVW

Anonymous — Fri, 23 Dec 2016 13:19:21 GMT

Of course, see this:

Regards!!

eromiyasimon — Fri, 23 Dec 2016 14:39:57 GMT

Hi Capella thanks for your reply, I find its helpful but all fields present in my table are all calculated fields and its huge calculations,

due to this im unable to add in the edit script as group.

is there any other way to achieve this ??

neelamsaroha157 — Fri, 23 Dec 2016 15:04:12 GMT

Take a look if this helps

Anonymous — Mon, 02 Jan 2017 07:11:21 GMT

Hi,

You can use calculated dimensions with aggr function.

Send some example of data.

Regards!

Anil_Babu_Samineni — Mon, 02 Jan 2017 07:32:03 GMT

Create Calculated Dimension

ValueList('A','B','C','D',....)

And then transpose to row level then see