topic Re: Text values in a Pivot Table in QlikView

Text values in a Pivot Table

Mon, 15 Jun 2015 01:18:35 GMT

Hi,

I'm struggling with the expressions on a pivot table,

My data is like this:

Product Price Date

A 26 5/5/15

A 27 23/7/15

B 32 23/7/15

And I want a pivot table that shows me the prices according to the date like this:

5/5/15 23/7/15

A 26 27

B - 32

Can anybody help me to figure out how the expression should be.. Does it have to be with the Aggr() function?

Thank youu

Re: Text values in a Pivot Table

settu_periasamy — Mon, 15 Jun 2015 01:49:05 GMT

Hi,

do you want like the below ?

find the attachment..

Re: Text values in a Pivot Table

Mon, 15 Jun 2015 03:08:38 GMT

Hi,

Please have a look at the attached file, hope it helps!

Kiru

Re: Text values in a Pivot Table

Mon, 15 Jun 2015 05:42:43 GMT

use 1st dimension as product

2nd as date.

expression as price.

you can even use only(price) as expression.

Re: Text values in a Pivot Table

Mon, 15 Jun 2015 14:25:12 GMT

Thank youuu !!! The Only function was what I was looking for

Re: Text values in a Pivot Table

Colin-Albert — Mon, 15 Jun 2015 14:29:42 GMT

It would be better to use avg(), min() or max() as the expression rather than only, as only() will return null if your product has different price values on the same date.

Re: Text values in a Pivot Table

Mon, 15 Jun 2015 14:43:07 GMT

Yeah, that's what I noticed I wrote a numerical example in the question I asked, but in my actual app I have text values, so as you say, I have null values. Do you know any kind of solution for this situation?

Re: Text values in a Pivot Table

Colin-Albert — Mon, 15 Jun 2015 14:52:59 GMT

You can use multiple expressions.

e.g. if(max(Price)>'', max(Price), maxstring(Price) )

If your price data is correctly formatted, I would not expect text values only numeric values