topic Re: Pivot Dimension in QlikView

Pivot Dimension

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am trying to take calculated dimension with exclude values

LOAD * Inline [

P_Des

All Plants

Battice

Birkeland

EPAD/Brussels

GOA

EPAD

];

Here,

1) I want to exclude All Plants & EPAD

2) Is it possible to move that Total values into Right part with last column. This is Pivot Table only.

- ANIL

Re: Pivot Dimension

sunny_talwar — Fri, 08 Jul 2016 11:18:56 GMT

1) I would use set analysis within your expression for exclusion

{<P_Des -= {'All Plants', 'EPAD'}>}

2) Do you want to see the total on the right side?

Re: Pivot Dimension

Anil_Babu_Samineni — Fri, 08 Jul 2016 11:35:36 GMT

Sunny,

1) P_Des is the Dimension. If i apply this on Dimension getting garbage error

2) Yes

Re: Pivot Dimension

varshavig12 — Fri, 08 Jul 2016 11:47:04 GMT

Try this:

1. if(P_Des<>'All Plants' or P_Des<>'EPAD', P_Des)

Re: Pivot Dimension

varshavig12 — Fri, 08 Jul 2016 11:49:33 GMT

2.) Not sure, but may be you are searching for this:

Re: Pivot Dimension

qlikview979 — Fri, 08 Jul 2016 11:50:45 GMT

Hi Varsha ,

He want total on right side of the table.

Regards

Re: Pivot Dimension

varshavig12 — Fri, 08 Jul 2016 11:54:37 GMT

Yeah, but he has drag his dimension horizontally.

Hence, thought so!

Re: Pivot Dimension

Anil_Babu_Samineni — Fri, 08 Jul 2016 11:54:53 GMT

If i try this, I don't know one more dimension is added, Like below

First field remover, But, I dont have last value which i tick the Yellow

Re: Pivot Dimension

qlikview979 — Fri, 08 Jul 2016 11:56:00 GMT

Hi Anil,

I hope ,may be this is help full to you?

How to get right total in Pivot table?

Re: Pivot Dimension

vinieme12 — Fri, 08 Jul 2016 11:59:07 GMT

or even this

=if(Wildmatch(P_Des,'All Plants','EPAD')=0,P_Des)

Re: Pivot Dimension

qlikview979 — Fri, 08 Jul 2016 11:59:47 GMT

Hi,

Pivot table - Total on the right side using formula

Re: Pivot Dimension

trdandamudi — Fri, 08 Jul 2016 11:59:53 GMT

The reason one more dimension is poping up because of nulls, check "Suppress When value is Null" in the dimension tab and that will take care of it.

Re: Pivot Dimension

Anil_Babu_Samineni — Fri, 08 Jul 2016 12:03:10 GMT

Yes, That is one way. But, i already check that. Anyway, The 0 showing Field not the value.

Re: Pivot Dimension

Anil_Babu_Samineni — Fri, 08 Jul 2016 12:04:11 GMT

Nothing change, Same as Varsha expression only

Re: Pivot Dimension

Anil_Babu_Samineni — Fri, 08 Jul 2016 12:05:07 GMT

Yes, I am changing the dimension from vertical to Horizontal , In this the total is not moved to right side?

Re: Pivot Dimension

sunny_talwar — Fri, 08 Jul 2016 12:06:41 GMT

Need to apply this to the expression.... Assuming you have Sum(Sales), change it to this:

Sum({<P_Des -= {'All Plants', 'EPAD'}>}Sales)

Re: Pivot Dimension

Anil_Babu_Samineni — Fri, 08 Jul 2016 12:07:01 GMT

I already check these two threads. But, First link is not useful for me. But, Second link showing similar to me. But i didn't understand this ?

Re: Pivot Dimension

Anonymous — Fri, 08 Jul 2016 12:10:52 GMT

You should read those thread entirely, with the IMAGES attached, then you will get to know..

Re: Pivot Dimension

vinieme12 — Fri, 08 Jul 2016 12:13:32 GMT

Can you post the sample?

Re: Pivot Dimension

sunny_talwar — Fri, 08 Jul 2016 12:16:04 GMT

Anil -

I would recommend avoiding calculated dimensions as much as possible. Your scenario is fairly simple which can be handled very easily using set analysis. If you can share your expression, we can propose where you need to add the set analysis I provided above.

Best,

Sunny