Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
psk180590
Creator III
Creator III

Dynamic Color only for Column not Sum

Hello All,

I would like to have Color in my Pivot Table when the number is greater then a particular value. But, the Color of the column Total must remain default.

Example:

Sales
30
40
50
10
12
14
16
89
83
Total: 344

Here, i would like to Color all the Columns above 40 with Yellow but, the Total  must remain the same.

Thanks!!

1 Solution

Accepted Solutions
stabben23
Master
Master

this could help, =if(RowNo()<>0 and ColumnNo()<>0 and Sum(Quantity) <> Sum(TOTAL Quantity) and Dimensionality() =3 and sum(Quantity) > 50, Yellow())

View solution in original post

20 Replies
YoussefBelloum
Champion
Champion

=if(  sum(Sales)<>sum(TOTAL Sales)  and sum(Sales) > YOUR_VALUE, rgb(YOUR_COLOR))

stabben23
Master
Master

This is could also be implemented in Background color in Your Expression.

Dimensionality()=1 if you have 1 Dimension, Dimensionality()=2 if you have 2 aso...

=if(Dimensionality()=1 and sum(Cost) > 40,rgb(255,255,0))

anjaneyulu
Creator
Creator

hi ,

   enable design grid>>

            right click on pivot table>>

                             custom cell format>>

                                                      text color

                    exp--------- if(sales>..  ,red()).


best Regards

   Anji

psk180590
Creator III
Creator III
Author

Thanks All for the quick suggestions.

But, somehow i'm not arriving at my goal. Have attached a sample app. Here in the Column Quantity i would like to have all above 50 in Yellow.

Anil_Babu_Samineni

You are not expecting this?

Capture.PNG

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)
psk180590
Creator III
Creator III
Author

Yes, this is what i'm looking to achieve.

Anil_Babu_Samineni

Then both of the above solution should work for BG color of expansion from expression

=if(Sum(Quantity)<>Sum(TOTAL Quantity)  and Sum(Quantity) > 50, Yellow())

=if(Dimensionality()=1 and Sum(Quantity) > 50,rgb(255,255,0))

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)
psk180590
Creator III
Creator III
Author

The problem is i'm also getting the color on the Total column

(I have color code for >20 here)

As in the below Screen shot(i masked out my Product Name) and also in the Row Total it is turning out Yellow.

Capture.JPG

I don't want color in the Total column.

Anil_Babu_Samineni

Do you used Pick(Dim, Field, 'Static1','Static2') as Dimension ??

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)