topic Re: Format Pivot Table in QlikView

Format Pivot Table

upaliwije — Wed, 23 Aug 2017 09:43:50 GMT

Hi Friends

I have following pivot table in my QV Doc

Here I want to adjust Due Dates Column without affecting the 1st Column(Expressions) When I try to adjust with 1st Column too Adjusted. If there is a way to do it pls advise me.

Re: Format Pivot Table

vinieme12 — Wed, 23 Aug 2017 10:18:05 GMT

Adjust the expressions affects all expressions , but adjusting the dimension should not affect the expression , can you post a sample?

I think you are holding the cursor over due_date instead hold cursor in the whitespace against a dimension value

Re: Format Pivot Table

upaliwije — Wed, 23 Aug 2017 10:34:24 GMT

Thanks Vineeth,

I have tried as you said, But with no success. I attach sample . Pls check & advise me

Re: Format Pivot Table

vinieme12 — Wed, 23 Aug 2017 10:53:50 GMT

Not with multiple expressions, you will need to create an island table that has the below list of values

Renewable

Renewed Prior to 15-Aug-17

Renewed between 15-Aug-17 and Due Date

Renewed on Due Date

Renewed within 1 week of Due Date

Renewed after 1 week of Due Date

Total Renewed

Renewed %

New Premium

and then use either IF() blocks or Pick(Match( to add expression for each value

see attached sample, i wasn't able to do a reload so i've used valuelist and If() blocks

Re: Format Pivot Table

upaliwije — Wed, 23 Aug 2017 11:03:57 GMT

Thanks Vineeth,

Pls also share with me a sample of Island table

Re: Format Pivot Table

vinieme12 — Wed, 23 Aug 2017 11:07:58 GMT

To create an island table, i will have to reload the app.

Please LOAd an inline table as below and post the updated app

LOAD * inline [

ExpressionsToUSE

Renewable

Renewed Prior to 15-Aug-17

Renewed between 15-Aug-17 and Due Date

Renewed on Due Date

Renewed within 1 week of Due Date

Renewed after 1 week of Due Date

Total Renewed

Renewed %

New Premium

];

Re: Format Pivot Table

upaliwije — Wed, 23 Aug 2017 11:21:30 GMT

I attach h/w updated app

Re: Format Pivot Table

vinieme12 — Wed, 23 Aug 2017 11:24:40 GMT

see attached

Re: Format Pivot Table

upaliwije — Wed, 23 Aug 2017 11:33:40 GMT

Thanks a lot

Re: Format Pivot Table

Anil_Babu_Samineni — Wed, 23 Aug 2017 11:33:52 GMT

Or just Straight table by enabling the Horizontal from presentation tab?