Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cupelix-qlik
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.

 

01234567891011121314151617181920212223
Monday6811051148524391927499897377807821549378087
Tuesday43860216836823325916828210079419842261981128
Wednesday258133769856398090431004929262870861086247894889
Thursday4773243895834111134253065213030455226354887865
Friday2149306439998708369946638207040116713868549120
Saturday151076989026131821514188487370803225716378445727
Sunday6794358846762888584433849317215114175957224269
2 Replies
swuehl
MVP
MVP

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

=lightgreen()

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.

cupelix-qlik
Contributor III
Contributor III
Author

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.