Dear Qlikview user
I am in the process of creating a pivot table of data where the same expression will be used several times, but the data will be displayed in text, image and gauge formatting. I am enclosing a screen shot of how my table looks at the moment
I have a dimension called Metric and the dimension is listed horizontally in the table
I want to show a circular gauge graph in my pivot table as one of my expressions. However each metric has a different target and at the moment I cannot get the gauge to show different the correct gauge colours per metric
Example of what I have written in the calculated colour settings of segment 1 of the gauge settings
=If(Num(sum({$<Fact_Date={'$(=Max(Fact_Date))'},Metric = {'A'}>}Value))
<=3,
$(vColour_RAG_Green),
If(Num(sum({$<Fact_Date={'$(=Max(Fact_Date))'},Metric = {'A'}>}Value))
>3,
$(vColour_Fail_Target),
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
If(Num(Sum({$<Fact_Date={'$(=Max(Fact_Date))'},Metric = {'B}>}TB_Numerator)
/Sum({$<TB_Fact_Date={'$(=Max(Fact_Date))'},Metric = {'B'}>}TB_Denominator), '#.#%')
<=0.95,
$(vColour_RAG_Green),
If(Num(Sum({$<Fact_Date={'$(=Max(Fact_Date))'},Metric = {'B'}>}TB_Numerator)
/Sum({$<Fact_Date={'$(=Max(Fact_Date))'},Metric = {''B}>}TB_Denominator), '#.#%')
>0.95,
$(vColour_Fail_Target)))
))
Some of the results are in % and others are just straight numbers. Could someone kindly point me in the right direction as to how I can get an expression, which is being represented as a gauge graph in a straight table to show the correct colours for different targets from different metrics
Kind Regards
Helen
