topic Re: Display MainGroup(1st-2digits) + LastGroup(last 4 digits) grouping in Pivot Table in QlikView

Display MainGroup(1st-2digits) + LastGroup(last 4 digits) grouping in Pivot Table

jim_chan — Wed, 26 Oct 2016 08:25:26 GMT

HI guys,

i have to create a pivot table to show the below information in each of the pivot table column.

column 1) List out same mainNo and SubNo record ID and category area

column 2) List out the mainNo + SubNo for thhis record_id

column 3) List out record ID and category_area which have diffrent MainNO+SubNo

I have attached sample. qvw file with inline data.

MK_QSL — Wed, 26 Oct 2016 08:26:50 GMT

Can you provide your output as well ?

jim_chan — Wed, 26 Oct 2016 08:34:37 GMT

sunny_talwar — Wed, 26 Oct 2016 11:11:26 GMT

This?

jim_chan — Wed, 26 Oct 2016 11:45:37 GMT

i waited you quite long bro.

not sure you can help me solve another issue or not.. can you ?

sunny_talwar — Wed, 26 Oct 2016 11:46:17 GMT

What issue? This one or another one?

jim_chan — Wed, 26 Oct 2016 12:20:32 GMT

haha. nope. this post:.

jim_chan — Wed, 26 Oct 2016 12:20:59 GMT

Sunny,

I will have a look on this in a short while.

Rgds,

Jim

jim_chan — Wed, 26 Oct 2016 12:23:18 GMT

wow..... thats correct! and you did it in the front end!

sunny_talwar — Wed, 26 Oct 2016 12:45:47 GMT

Hahahaha yes I did