topic Re: Pivot Table in QlikView

Pivot Table

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I need to format my pivot table so it looks like more like the above. I can't figure out how to do it. I've tried every trick in the bag. I currently have the bottom and need to alter so it can resemble like the one above.

Please provide assistance.

Re: Pivot Table

sunny_talwar — Wed, 06 Apr 2016 12:45:04 GMT

Wait isn't this how it was when we did it in the last post?

Like this I mean

Re: Pivot Table

Wed, 06 Apr 2016 12:48:13 GMT

Can you provide some sample data or sample qvw?

Regards,

Anjali gupta

Re: Pivot Table

MK_QSL — Wed, 06 Apr 2016 12:48:53 GMT

Simply by using Pivot Table, you can't achieve this... Use Straight Table.

Re: Pivot Table

sivarajs — Wed, 06 Apr 2016 12:50:17 GMT

Place cursor on monthyear column (shows blue arrow)and Drag over count column

Re: Pivot Table

Wed, 06 Apr 2016 12:50:42 GMT

try to drag the Dimension that you want to set as column

to do that you need to click and hold the left button then move the mouse to the upper side of the table

you will see a blue line that shows where you want to put the dimension

Re: Pivot Table

sunny_talwar — Wed, 06 Apr 2016 12:51:20 GMT

Drag MonthYear to the corner and it should be pivoted

Re: Pivot Table

Wed, 06 Apr 2016 12:53:03 GMT

Yes I need to make a new one just like it. It's a pivot table but I don't know how to display it in that fashion.

Re: Pivot Table

MK_QSL — Wed, 06 Apr 2016 12:57:22 GMT

@aaqureshi2010‌is this what you want?

I think it was clear from your question that you don't want rows having null or 0 values.

i.e. for MONTHYEAR Oct 2015, you don't need line for MonthYear Oct 2015.

Correct me if I am wrong... otherwise accept my apology for misunderstanding your question.

Re: Pivot Table

Wed, 06 Apr 2016 13:01:38 GMT

I need to have the months colored differently in the table for each row horizontally? Sep 2015 to Feb 2016. Can someone provide insights.

Thanks,

Re: Pivot Table

sunny_talwar — Wed, 06 Apr 2016 13:05:03 GMT

Like this may be?

Re: Pivot Table

Wed, 06 Apr 2016 13:06:22 GMT

Hi MRKachhiaIMP

Just wanted to get the format of the pivot table corrected. It was as easy as moving the cursor 'til I saw the blue area. Thanks for checking Manish.

Re: Pivot Table

MK_QSL — Wed, 06 Apr 2016 13:06:48 GMT

Go to your Expression Tab

Click on + sign

Write below expression under Background Color

IF(Odd(RowNo()),Green(),Yellow())

Change Green() and Yellow() to your desired color.

Re: Pivot Table

Wed, 06 Apr 2016 13:08:36 GMT

Thanks Sunny is there anyway I can have different colors for each row? It's difficult to differentiate between the colors.

Re: Pivot Table

sunny_talwar — Wed, 06 Apr 2016 13:27:17 GMT

You can use something like this:

=Pick(RowNo(), LightBlue(), LightRed(), LightCyan(), LightGray(), LightGreen(), LightMagenta())

Change the colors to whatever you would like them (may be use RGB)

Re: Pivot Table

Wed, 06 Apr 2016 13:37:34 GMT

Thanks for all your help community!!!!!