Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

2 Gauges with different selection criteria

HI!, this is my first question, Im new to QlikView.

What I want to do is simple:

2 Guages.

The first one displays the completion% according to a sales goal of the current day. (Using DocDate as Dimension and SUM(Quantity) as Expression)

The second one displays the completion % according to a sales goal for the current month. (Using MonthID as Dimension and SUM(Quantity) as Expression)

My code for data load:


SQL
SELECT
DocDate
,CardCode
,CardName
,ItemCode
,ItemName
,Quantity
,CONVERT(varchar(20),MONTH(DocDate)) + CONVERT(varchar(20),YEAR(DocDate)) as MonthID
FROM ODLN


If I select the correct MonthID I get the 2nd gauge correct. But when I select the current date, the 2nd Gauge only displays data for the current date.

Can anyone suggest me a better way?

Thank you,

Jose.

Tags (1)
Community Browser