topic Re: Pivot table issue in QlikView

Pivot table issue

kkkumar82 — Mon, 09 May 2016 11:55:26 GMT

Hi ,

Any ideas on the above in pivot table

Re: Pivot table issue

sunny_talwar — Mon, 09 May 2016 12:04:58 GMT

Not sure I understand the issue?

UPDATE: Can you may be elaborate?

Re: Pivot table issue

kkkumar82 — Mon, 09 May 2016 12:07:49 GMT

Hi Sunny,

the first table is the way data is and the customer is wishing to see it in the second way , and I am trying to do it in Pivot using above etc but couldn't get it.

Can you suggest any thing without any changes in the edit script.

Thanks

Kiran

Re: Pivot table issue

tamilarasu — Mon, 09 May 2016 12:10:20 GMT

Try like below,

Temp:
LOAD * INLINE [
    Sno, Prod Family, Product, Category, Qty
    1, Accessories, Mouse, Hardware, 2
    2, Accessories, Keyboard, Hardware, 3
    3, Accessories, Headset, Hardware, 1
    4, Computer, Windows, S/W, 1
    5, Computer, Office, S/W, 1
];

NoConcatenate
Load RowNo() as Sno, *;
Load [Prod Family],
      Concat(Product,', ') as Product,
      Category,
      Sum(Qty) as Qty
Resident Temp Group by [Prod Family],Category ;
      
DROP Table Temp;

Note: Try to post data instead of picture.

Re: Pivot table issue

florentina_doga — Mon, 09 May 2016 12:14:20 GMT

see attach

Re: Pivot table issue

kkkumar82 — Mon, 09 May 2016 12:14:37 GMT

Hi Nagraj,

Thanks for your suggestion, but is there a way that we can do it from from end , because we customer don't want to miss the details.

Kiran

Re: Pivot table issue

sunny_talwar — Mon, 09 May 2016 12:17:06 GMT

Like this?

Re: Pivot table issue

tamilarasu — Mon, 09 May 2016 12:20:37 GMT

Fine. Check the attachment.

Re: Pivot table issue

tamilarasu — Mon, 09 May 2016 12:23:31 GMT

Yes. Chr(10) is appropriate in this case.

Re: Pivot table issue

sunny_talwar — Mon, 09 May 2016 12:25:55 GMT

Kumar -

Tamil‌ brought up a great point. It becomes very easy for us to provide a sample if the raw data is not provided as an image. He had to type that up which requires a lot of time and effort. You can continue to post the images, but do include raw data in the form which we can use to just copy paste to create a sample application for you.

Best,

Sunny

Re: Pivot table issue

kkkumar82 — Mon, 09 May 2016 12:27:37 GMT

Thanks sunny as always, thats a good trick

Re: Pivot table issue

kkkumar82 — Mon, 09 May 2016 12:29:13 GMT

Apologies all, in a hurry I did that, I will definitely follow it.

Re: Pivot table issue

kkkumar82 — Mon, 09 May 2016 12:30:14 GMT

thanks for you efforts, but thats not what I require.

Re: Pivot table issue

sunny_talwar — Mon, 09 May 2016 12:35:37 GMT

No apologize needed my friend. As long as you make an effort from next time, we are all good

Best,

Sunny

Re: Pivot table issue

HirisH_V7 — Mon, 09 May 2016 12:54:39 GMT

Hi,

May Be like this,

Using a

Calculated Dimension:

For Product

=aggr(concat(Product,', ' ),[Prod Family])

Expression:

Aggr(Sum(Qty),[Prod Family])

Pivot Table Looks like this,

HTH,

PFA.

Hirish

Re: Pivot table issue

Tue, 10 May 2016 06:10:33 GMT

Thank You.