topic Re: Issue in Pivot table in QlikView

Issue in Pivot table

nareshthavidishetty — Thu, 27 Aug 2015 17:46:28 GMT

hi all,

please find the below screen shot, My requirement is like.

I have the data like

i want to show these values in pivot table like below screen shot order should be(A,B,C,D).

But,when i am trying to do this ,it is showing like below screen shot

Can you please help on these guys.

warm Regards,

Naresh

Re: Issue in Pivot table

Qrishna — Thu, 27 Aug 2015 17:52:46 GMT

Try a Straight table if you dont want pivot properties.

Re: Issue in Pivot table

sinanozdemir — Thu, 27 Aug 2015 18:05:39 GMT

Maybe something like this:

I am attaching the qvw in case.

Re: Issue in Pivot table

nareshthavidishetty — Thu, 27 Aug 2015 18:34:42 GMT

Hi Sinan,

Thanks for your reply,

I am looking data like this only,but in qvw i am not able to find pivot table in front end like this.

Please provide me logic what you have done like this completely in QVW.

Warm Regards,

Naresh

Re: Issue in Pivot table

sinanozdemir — Thu, 27 Aug 2015 18:45:17 GMT

You should be able to open up my qvw which I previously attached. Although, here are the steps to get a pivot table like this:

Bring the dimension A, and in the label put the below expression and also change the text color to white:

2. Bring dimension B and put the below expression in the label box:

3. Add a calculated dimension as shown below to get the overall totals and label it as ST:

4. And lastly, in the expression, add the below Sum() expression and the label expression is =chr(10). After that drag the calculated column to the top.

Hope this helps.

Re: Issue in Pivot table

nareshthavidishetty — Thu, 27 Aug 2015 19:02:29 GMT

Tanks for you quickresponse ,

But my data is like

A	B	C	D
1	8/1/2015	ST	488
1	8/2/2015	ST	283
1	8/3/2015	ST	705
1	8/4/2015	ST	512
1	8/5/2015	ST	471
2	8/1/2015	BT	100
2	8/2/2015	BT	100
2	8/3/2015	BT	100
2	8/4/2015	BT	100
2	8/5/2015	BT	100

problem is, the Data in 'C' Column will continue Like(ST,BT,TT,MtT)

Warm Regards,

Naresh

Re: Issue in Pivot table

nareshthavidishetty — Thu, 27 Aug 2015 19:32:52 GMT

Hi Sinan,

I am looking like this,

Regards,

Naresh

Re: Issue in Pivot table

nareshthavidishetty — Thu, 27 Aug 2015 19:36:08 GMT

Hi sinan,

I am looking like this,Including column names(A,B,C,D)please find below screen shot.

Warms Regards,

Naresh

Re: Issue in Pivot table

sinanozdemir — Thu, 27 Aug 2015 20:06:21 GMT

This is as close as I can get:

If this is not, what you are after then you may need to create some additional dimensions in the load script.