Conditional Statements to highlight shell for a Pivot Table in Qlik Sense

Sun, 04 Oct 2015 03:06:12 GMT

Hi All,

I am new to Qlik Sense and i am trying to build some reports. I could able to do all my reports on my its own with little help of documentation but i am stuck in one report.

I have built a Pivot table which has Row and Columns as below tables and measure is count of statements for that month.

I would like to highlight all the shells in RED if count has increased or decreased more than 50% compared to previous month.

Example: Abort statement

Jan: count was 10

Feb : Count was 20

So i would like to highlight 20 as red. Similarly it should check all the shell

Statement Type	2015-01	2015-02	2015-03	2015-04	2015-05	2015-06	2015-07	2015-08	2015-09
Abort	10	20	40	41	28	30	31	40	41
Alters	20	21	22	34	45	11	15	20	11
Select	1000	1090	2090	2300	1600	1500	1100	1200	1300
Insert	590	555	689	566	343	1200	2990	2888	1700

-Sam

Re: Conditional Statements to highlight shell for a Pivot Table in Qlik Sense

sinanozdemir — Mon, 05 Oct 2015 00:19:18 GMT

Hi Sam,

Let me know if this is what you are looking for:

I am attaching the example app as well.

Hope this helps.

Thanks

Re: Conditional Statements to highlight shell for a Pivot Table in Qlik Sense

Anonymous — Mon, 05 Oct 2015 01:59:32 GMT

Sinan,

Its perfect. Before did the trick

Thank you.

topic Re: Conditional Statements to highlight shell for a Pivot Table in Qlik Sense in QlikView

Conditional Statements to highlight shell for a Pivot Table in Qlik Sense

Re: Conditional Statements to highlight shell for a Pivot Table in Qlik Sense

Re: Conditional Statements to highlight shell for a Pivot Table in Qlik Sense