topic Pivot Table / Above() Function Help in QlikView

Pivot Table / Above() Function Help

Sat, 19 Jul 2014 18:35:45 GMT

Please could someone provide an example on how to create a pivot table like below?

The %change is calculated with the %above function. I wish to place it below FY14 instead of as a column (i.e. to the right with the Wins column) and apply conditional format to all 3 cells (i.e. FY15, FY14 and %Change) if %Change is either >=0 (Green) or <0 (Red).

Re: Pivot Table / Above() Function Help

israrkhan — Sat, 19 Jul 2014 22:47:40 GMT

can you share A sample doc. will be easy to answer.

Re: Re: Pivot Table / Above() Function Help

Sun, 20 Jul 2014 23:18:42 GMT

Sample file attached

Re: Pivot Table / Above() Function Help

SergeyMak — Mon, 21 Jul 2014 01:19:50 GMT

Hi Lawrence,

PFA

Regards,

Sergey

p.s: I calculated period based on its definition, but it would better to do based on calendar table

Re: Pivot Table / Above() Function Help

israrkhan — Mon, 21 Jul 2014 01:35:01 GMT

i was preparing it, and i saw you already got the answer...

Kind Rgards

Khan