topic Re: Expression promoting in pivot in QlikView

Expression promoting in pivot

Wed, 22 Apr 2015 07:26:14 GMT

Hi all,

i am faceing problem with expression in pivot .i want to promote exp(sales) in pivot.my requriement is

CUST MONTH SALES
A JAN 100

B JAN 200

TOTAL 300

D FEB 500

E FEB 200

TOTAL 700

I WANT TO O/P like this:

sales CUST MONTH
100 A JAN

200 B JAN

300 TOTAL

500 D FEB

200 E FEB

700 TOTAL

plz help me on this.

regards,

Re: Expression promoting in pivot

Gysbert_Wassenaar — Wed, 22 Apr 2015 07:43:19 GMT

That's not possible in a pivot table afaik. The dimensions are always shown on the left side (or on top if you pivot them) and the expression on the right side.

Re: Expression promoting in pivot

Wed, 22 Apr 2015 07:48:29 GMT

Hi Gysbert,

Thanks for ur quick reply,Is there any possible to add the one new dimension at first ,it shows the led's like red,green symbols based on sales exp.

Thanks ,

Rk.

Re: Expression promoting in pivot

Gysbert_Wassenaar — Wed, 22 Apr 2015 08:00:11 GMT

No, only expressions can be shown as leds. But you can give the dimension values a different background color based on the value of the expression. Click on the + in front of the dimension, select Background Color and click on the Edit button to open the expression editor to enter an expression that calculates the color. For example:

if(sum(SALES)>400, green(), if(sum(SALES)>200, blue(), red()))