topic Re: Pivot Table in QlikView

Pivot Table

MarcoARaymundo — Tue, 19 Mar 2013 19:00:36 GMT

Hi!

How to create a pivot table like below example.

Estoque

Pedido em Carteira

Exp. - Dia Anterior

Prd. - Dia Anterior

Prc. Médio/Mês - NET

Produto

Qtd.

U.M.

Qtd.

U.M.

Qtd.

U.M.

Qtd.

U.M.

Ped.Pend

Faturado

Mix

tks

Re: Pivot Table

Gysbert_Wassenaar — Wed, 20 Mar 2013 11:58:07 GMT

If Qtd., U.M., Ped.Pend and Faturado Mix are expressions then it is not possible to create the pivot table you want. All expressions will be shown for all values of dimensions in the pivot table. No exceptions possible.

Re: Pivot Table

MarcoARaymundo — Wed, 20 Mar 2013 12:04:58 GMT

Thanks Gysbert!

But in expressions have a conditional enable, i think use conditional like if(ColumnNo()=X,1,0), but dont work.

Any idea how to use a conditional expression?

Re: Pivot Table

Gysbert_Wassenaar — Wed, 20 Mar 2013 12:11:17 GMT

No exceptions possible.

No buts either

Feel free to prove me wrong

Re: Pivot Table

MarcoARaymundo — Wed, 20 Mar 2013 12:32:14 GMT

"Feel free to prove me wrong"

LOL

Thanks!

Re: Pivot Table

Wed, 05 Feb 2014 18:53:59 GMT

Hey guys,

I am given a task to calculate the frequency of calls across a territory. If the rep called a physician regarding the sale of the product 5 times, then frequency is 5 and HCP count is 1....I generated frequencies from 1 to 124 in my pivot table using a calculated dimension which is working fine. But my concern is :

My manager wants frequencies till 19 in order from 1..2..3..4...5..6.....19...

And from the frequency 21-124 as 20+.

I would be grateful if someone helps me with this.....Eager for the reply....

Re: Pivot Table

Anonymous — Wed, 05 Feb 2014 19:10:47 GMT

Marco,

You can create a pivot table with two expressions Qtd. and U.M., and without "Prc. Médio/Mês - NET". Create a separate table with "Prc. Médio/Mês - NET" only and with four expressions. Place these tables next to each other.
It may or may not work for you, depending on the overall behavior of the tables.

Regards,
Michael
PS: It does not proves Gysbert wrong because I'm suggesting two tables.

Re: Pivot Table

Anonymous — Wed, 05 Feb 2014 19:12:14 GMT

Abhi, if you are not a robot and have a question, please create your own discussion rather than posting in multiple discussions.

Re: Pivot Table

Wed, 05 Feb 2014 19:13:44 GMT

i am not able to do that...