topic Re: Pivot table allignment in QlikView

Pivot table allignment

Anonymous — Thu, 23 Feb 2017 15:59:10 GMT

I have a pivot table where i need to use expression with out any count or sum..

Could you please look at the attachment and suggest me please

Re: Pivot table allignment

Anonymous — Thu, 23 Feb 2017 16:07:51 GMT

any help?

Re: Pivot table allignment

datagrrl — Thu, 23 Feb 2017 16:15:10 GMT

I am not sure I understand what you are asking. It sounds like you are really using the number as a dimension and not an expression.

Re: Pivot table allignment

Anonymous — Thu, 23 Feb 2017 16:24:34 GMT

Hi thanks for the response,

Yes my dimensions are numbers and text .. AreaID & KPICateogory

and in the expression i am using numden(which is also nunber), i dont want to apply any count or sum on this feild.

Any suggestion

Re: Pivot table allignment

Anonymous — Thu, 23 Feb 2017 16:39:58 GMT

any one to help?

Re: Pivot table allignment

vishsaggi — Thu, 23 Feb 2017 16:50:21 GMT

What is that you want to see in the NUMDEN expression ? Give us an expected output you are looking for this? You want the minimum number or max number or what exactly you want ?

Re: Pivot table allignment

krishnacbe — Thu, 23 Feb 2017 17:07:29 GMT

Hi,

Try to use Only(NUMDEN) in the expression.

Re: Pivot table allignment

krishnacbe — Thu, 23 Feb 2017 17:12:12 GMT

You want to apply some function.

Try with Min(NUMDEN) or Max(NUMDEN)

Re: Pivot table allignment

datagrrl — Thu, 23 Feb 2017 18:15:43 GMT

I think the only and min and max do not work because there are many values for NumDen still for each AreaID and KPI.

Maybe using NumDen as a dimension, then you can use the Only function. If it were a straight table you could then hide the dimension. I think maybe you could play with the pivot table style to get this to work.

I could be pointing you the wrong way. The solution isn't obvious to me.

Re: Pivot table allignment

Anonymous — Thu, 23 Feb 2017 18:49:20 GMT

thanks for the help

all those are gone in not in use.....

Re: Pivot table allignment

vishsaggi — Thu, 23 Feb 2017 19:53:17 GMT

Quite did not get what you mean by this?