Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivottabel: colored visualisation of different options

Dear experts,

I need your help in QlikView :

I created a pivottable with following column:

- Tolerance - is defined in the excel

- IstSum - working fine (a long formel)

- SollSum - woriking fine (a long formel)

- Evaluation - Doesn't work

In the last column "Evaluation" I have to visualize the result with color and text:

if IstSum > SollSum*(1+Tolerance/100) --> red color (text:too high)

if IstSum < SollSum*(1-Tolerance/100) --> orange color (and text: too few)

if IstSum between SollSum*(1+Tolerance/100) and SollSum*(1-Tolerance/100) --> green (text: im Range)

It seems to be very easy, but I don't know where I can define these three formulas.

I created two variable: tolerance_over (Toleranz_oberhalb) and tolerance_few (Toleranz_unterhalb).

I use these variables in "Visualization", but I cannot use this formulas for "normal"--> "im Range". And these formulas refer to "formulas" and here I don't know, how I can insert 3 formulas.

How can I resolve this problem ? Are there any other alternative (maybe over the "picture")?


Thank you and kind regards,

André

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

I'm not sure if it will be possible with the options from tab "Visualisierungen" but it should work with a color-expression on those expression - here you find an example and further possibilities for Colors in charts.

- Marcus

View solution in original post

5 Replies
Gysbert_Wassenaar

Can you post a small qlikview document that illustrates the problem?


talk is cheap, supply exceeds demand
Not applicable
Author

Hello Gysbert,

in the attachment you will find screenshot of the excel-sheet with formulas, how it has to be in qlikview.

Column "U", "V", "W" are working in QlikView.

I need to develop column "X".

I hope it helps to understand my problem.

Kind regards,

Not applicable
Author

tolerance.JPG

marcus_sommer
MVP & Luminary
MVP & Luminary

I'm not sure if it will be possible with the options from tab "Visualisierungen" but it should work with a color-expression on those expression - here you find an example and further possibilities for Colors in charts.

- Marcus

View solution in original post

Not applicable
Author

Thank you, it helped me !

it works in this combination:

Color-value in color-expression and text in definition

In the color-expression I have:

if ($(Bestellung_Plan_Std)*((1-Toleranz)>Sum(Std)), Yellow(),

if ($(Bestellung_Plan_Std)*((1+Toleranz)<Sum(Std)),Red(),

Green()))

and in the definition I valuate a text:

if ($(Bestellung_Plan_Std)*((1-Toleranz)>Sum(Std)), 'zu gering' ,

if ($(Bestellung_Plan_Std)*((1+Toleranz)<Sum(Std)), 'zu hoch',

'im Range'))