Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Nora104
Partner - Creator
Partner - Creator

How to make the summary row not show color in pivot table

The below is 4 indexes of a code:

1.png

I want it to be like this, when index B is less than 70%, it is marked orange, but the summary row is not marked orange:

2.png

But I don't know how to write the formula.4.png
I use the formula :if(count(distinct Code)=1 and sum(index_B)<0.7,RGB(255,128,64),)
But it only works when there are more than one code.

If there is only one code, it would be like the below:

3.png

How can I write the formula?

1 Solution

Accepted Solutions
MayilVahanan

Hi @Nora104 

Little bit confused. 

Try like below

if(RowNo()<>0 and count(distinct Code)=1 and sum([index B])<0.7,RGB(255,128,64))

MayilVahanan_0-1608029351246.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

6 Replies
MayilVahanan

HI @Nora104 

Can you provide the sample app..

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Nora104
Partner - Creator
Partner - Creator
Author

 
MayilVahanan

Hi @Nora104 

For me, its working fine. 

MayilVahanan_0-1608027471626.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Nora104
Partner - Creator
Partner - Creator
Author

Hi @MayilVahanan 

I want it to be like the below:

1.png

I don't need the summary row to be marked orange.

MayilVahanan

Hi @Nora104 

Little bit confused. 

Try like below

if(RowNo()<>0 and count(distinct Code)=1 and sum([index B])<0.7,RGB(255,128,64))

MayilVahanan_0-1608029351246.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Nora104
Partner - Creator
Partner - Creator
Author

Wow, it's just what I want! Thank you!