topic Linear gauge in straight table in QlikView

Linear gauge in straight table

Mon, 09 Dec 2013 12:59:07 GMT

Hi,

I have some problems with the display of the length of each linear gauge in a straight table with a drill-down dimension.

This first picture above shows the result in the first stage of the drill-down. This looks nice, the row with the highest value is 100% filled.

The next picture show the second stage of the drill-down. As you see now the row with the highest value is not 100% filled, instead its filled as the amount of the total amount.

The code below is what I have implemented in the box for max in Gauge Properties.

RangeMax(

Alt(max(

TOTAL Aggr($(v_GSV_CPPeriod_vs_GSV_LYPeriod_Positive), [Salesorganisation Name])), 1),

Alt(min(

TOTAL Aggr($(v_GSV_CPPeriod_vs_GSV_LYPeriod_Negative), [Salesorganisation Name]))*-1, -1)

)

The other columns in the drill-down is [Customer Group Name] and [Customer Name].

I would like to fill the row with the highest value to 100% everytime, regardless of which stage of drill-down. How can I change the script to enable this?

Thanks in advance,

Fredrik

Re: Linear gauge in straight table

Anonymous — Mon, 09 Dec 2013 14:27:47 GMT

I guess, you need to edit the expression that you have used in the below space.

Hope that helps.

Regards,
Aadil

Re: Linear gauge in straight table

Mon, 09 Dec 2013 14:39:54 GMT

Hi,

That does not work. I the initial express window I only implement the variable $(v_GSV_CPPeriod_vs_GSV_LYPeriod_Positive) for the green line and $(v_GSV_CPPeriod_vs_GSV_LYPeriod_Negative) for the red line.

Re: Linear gauge in straight table

Anonymous — Mon, 09 Dec 2013 14:43:38 GMT

can you post a sample app.. it will be easier that way...

Re: Re: Linear gauge in straight table

Tue, 10 Dec 2013 08:20:17 GMT

Hi,

Attached is a sample app. I want regardless of the level off drill-down that the row with the highest value in either +/- will be 100% filled.

Thanks,