Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!