Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Pivot Table Help Required

Is it possible within Qlikview a create a Cross-Tab data table which is colour coded relative to the other data. As per Image below from Excel.

I am still learning what can and can't be done in Qlikview. Now I know i can create a Pivot table to create the data, but I don't know how to colour it based on the selections, my Max & Min numbers are variable depending on which hospital I am looking at.


2 Replies

You can set the colors as expression color attribute in expression tab, open the expression attributes by clicking on the small plus sign next to the expression name on upper left.

You would need to create a color expression, something that returns a color code, for example a static color:

=RGB(100, 140, 50)



Or a dynamic color

=if( sum(Value) <= 10, lightred(), lightgreen() )

You would need to describe your requirements a bit more detailed (best by also uploading a small sample QVW), if you want more help on the expression.

Contributor III
Contributor III

The data shows a Hourly Breakdown by Day for activity within Hospitals.

Each Hospital has a unique & variable pattern depending on the time scale selected (Week,Month, Quarter etc)

So in my example data above On the Wednesday @ 11 am there was 100 arrivals at the hospital within that Hour slot which would be coloured Green (for Max number anywhere within the data shown) where as Monday @ 9am there was only 1 arrival in that Hour Slot which would be Coloured Red (for Min Number within the data shown)

The Min can be a Zero and the Max could be any number. The Colour of each Hour Slot across the entire table is based on the Min & Max of the data shown. Red for Min & Green for Max this is then shaded on a sliding scale between those colours so that a mid range entry would appear Yellow/Orange.

As I can't know in advance what the Max or Min will be as this will determined by which Hospital has been selected and what time range has been selected.

So based on your Dynamic colour I wouldn't know what the value the 10 should be and that would only colour 2 colours rather than my example which has a sliding scale of colours to help identify where the problem area's are.

Hope this helps. I created the above in Excel so don't have a Qlikview doc to give.