Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
SNR1
Creator
Creator

how ot show color for total based on groups in straight table ASAP

Hi All,

i have values like below and need colour for total based on groups for different group need to show different color ASAP

Capture3.PNG

 

Thanks in Advance

please help us

 

5 Replies
Shubham_Deshmukh
Specialist
Specialist

Can you elaborate more?
SNR1
Creator
Creator
Author

Hi All,

 

based on jeery one color in output values in in my expression

 

for level 2 total need to show one color

level 3 for one more other color like that

Anil_Babu_Samineni

You can get it using work around. Will you provide sample to test?
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ahmed_hassan
Contributor III
Contributor III

Check that, maybe it fulfill your needs.

Shubham_Deshmukh
Specialist
Specialist

Do some Resident Load stuff with your data like below,

data:
load * inline
[
A, B , C
X, 2, 4
Y, 3, 7
];
Concatenate

LOAD 'total' as A,sum(B)as B,sum(C)as C Resident data;

This will add total of you columns at the end and then you can set background color (with condition =if(A='total',Red())) from expression tab, hope you are expecting this as below,

av.png