topic Re: Problem with Trellis Gauge chart in QlikView

Problem with Trellis Gauge chart

Fri, 09 Sep 2011 12:59:09 GMT

Hi,

I am trying to have 2 trellis gauge charts to show last years figures(on the 1 gauge) compared to this years(on the other gauge).

The problem is it shows both gauges but only one gauge has an indicator. Please find my code below:

=Sum({$<Fiscal_Year1={$(=Only(Fiscal_Year1))}>}PO_Spend)/
Sum({$<Fiscal_Year1={$(=Only(Fiscal_Year1))}>}Total_Spend)

=Sum({$<Fiscal_Year1={$(=Only(Fiscal_Year1)-1)}>}PO_Spend)/
Sum({$<Fiscal_Year1={$(=Only(Fiscal_Year1)-1)}>}Total_Spend)

Regards,

Nhlanhla

Re: Problem with Trellis Gauge chart

Fri, 09 Sep 2011 13:16:25 GMT

Hi Nhlanhla,

if i understand ur problem and if u want to use trellis, u have to use only 1 expression and use "Fiscal_Year1" as trellis dimension.

Look at my example.

C u ,

Stefano.

Re: Problem with Trellis Gauge chart

Fri, 09 Sep 2011 13:52:51 GMT

Nhlanhla,

If you calculate previous to selected period you should use {1} instead of {$} as previous period might be out of current selection. So in your case right expression for second gauge should be:

=Sum({1<Fiscal_Year1={$(=Only(Fiscal_Year1)-1)}>}PO_Spend)/

Sum({1<Fiscal_Year1={$(=Only(Fiscal_Year1)-1)}>}Total_Spend)

Re: Problem with Trellis Gauge chart

Fri, 09 Sep 2011 14:04:22 GMT

Hi,

tray this,

let me know.

Re: Problem with Trellis Gauge chart

Fri, 16 Sep 2011 07:53:16 GMT

Thanks guys it works...Much Appreciated