topic Re: Pivot table conditional background is not working in App Development

Pivot table conditional background is not working

pranaligawde — Sat, 11 Apr 2020 10:23:20 GMT

Hello All,

I am trying to get conditional background colour in qlik sense.but my two expressions are not compairing correctly.

Kindly advice .what to do?

below is the expression

set analysis:

if(KPI_Type='Actual' and Round(sum({<KPI_Type={'Actual'}>}Value))>Round(sum({<KPI_Type={'Target'}>}Value)), '#00ff99',
if(KPI_Type='Actual' and Round(sum({<KPI_Type={'Actual'}>}Value))<Round(sum({<KPI_Type={'Target'}>}Value)), '#ff9999',
if(KPI_Type='Actual' and (Round(sum({<KPI_Type={'Actual'}>}Value))='0'), '#c2cbcb'))
)

Re: Pivot table conditional background is not working

ogster1974 — Sat, 11 Apr 2020 11:25:19 GMT

Use Aggr() Function to compare at FMonth Grouping level.

Re: Pivot table conditional background is not working

pranaligawde — Mon, 04 May 2020 10:09:41 GMT

yes i did that,and got the result as well.

Thank you😊