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.