topic Re: help in pivot table in QlikView

help in

Fri, 20 Nov 2015 16:25:14 GMT

i have a pivot table with dimension

i am attaching the sample app. please look into it and let me know the suggestions

Re: help in pivot table

Fri, 20 Nov 2015 17:25:50 GMT

if you are looking for something like this, where the numbers are green or red

you want to expand the expression (the + sign) and go into Text Color and use the following expression

=if (Count(SaleID) > 5, rgb(0,130,0), RGB(255,0,0))

if you want the color of the cell to change to red or green, then isntead of putting the above expression in the txt color property place it in the background color property

Re: help in pivot table

Fri, 20 Nov 2015 17:34:01 GMT

Thanks Adam

I need to compare for every two years like 2012, 2013 ....... 2013 and 2014 ........ 2014 and 2015 like this

not for the whole years count of sales.

Re: help in pivot table

Fri, 20 Nov 2015 17:42:16 GMT

ahhh - sorry misunderstood

I think you want to use the same concept using set analyis in the expression of the color

Re: help in pivot table

gsbeaton — Fri, 20 Nov 2015 17:44:33 GMT

Hi,

You can use the Above() function to get the value of the cell above, which will allow you to determine the text colour to apply. Something similar to this should work: if (above(Count(SaleID)) > Count(SaleID), red(), green());

Re: help in pivot table

Fri, 20 Nov 2015 17:45:10 GMT

thanks Adam for the response

i am trying it out but not success

Re: help in pivot table

sinanozdemir — Fri, 20 Nov 2015 17:49:11 GMT

I came up with this atrocious expression, let me know if this works for you:

Re: help in pivot table

Fri, 20 Nov 2015 17:51:04 GMT

have you tried the expressions Sinan sent?

Re: help in pivot table

gsbeaton — Fri, 20 Nov 2015 17:57:23 GMT

Hi Sinan,

Well if it works it's not wrong

However, if there is a lot of data, that expression is going to run very slowly. Using the inter chart function Above() will allow you to get to the value in the cell above without having to do a whole load of recalculations.

George

Re: help in pivot table

Fri, 20 Nov 2015 18:06:37 GMT

Hello George

Thanks for the response but unfortunately above() is not near to the requirement,

Re: help in pivot table

Fri, 20 Nov 2015 18:11:06 GMT

Thanks Sinan

your expression near to the requirment but if i increase the % to 10 its not working

Re: help in pivot table

sinanozdemir — Fri, 20 Nov 2015 18:17:41 GMT

Are you entering the percentage as 0.10? You can also gsbeaton's suggestion as below:

Re: help in pivot table

Fri, 20 Nov 2015 18:22:55 GMT

Hello Sinan

Thanks alot, yes i am using 0.10 for 10% but not giving results

Re: help in pivot table

sinanozdemir — Fri, 20 Nov 2015 18:23:04 GMT

Try to enter the percentage as 0.01 for 10%.