Qlikview Gauge chart

[Anonymous]

Guys,

A per my requirement, I have a gauge chart in one sheet if that chart gets selected it should be navigated to another sheet, where a filter value should be selected.

Expression: =count(Aggr(if($(vBillingstatus)>7,EmployeeID),EmployeeID))

No dimension

If the above chart is selected, I can able to navigate to the sheet I want but couldn't make the filter selected.

Expression for billing type:

=If($(vBillingstatus)>7 , 'Billable',

  If($(vBillingstatus)>3 and $(vBillingstatus)<8 , 'Partially Billable',

  If($(vBillingstatus)<4 , 'Non-Billable' )))

vBillingstatus = Aggr(Sum(MonthlyBillableWorkHour)/Count(Total <EmployeeID, Month> DISTINCT Timesheet),EmployeeID)

This is the filter in another sheet, if that non billable chart gets selected Non-Billable value should be selected in this Billing type (Filter).

please  help

regards

Siva Bose

[vishsaggi]

Can you share a sample to look into?