Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a line chart that shows the count of all transactions for a given date (selected my picking year/month/day).
The Y axis shows the count and X axis shows the hours of the day that the transactions took place.
I need to now add a second line to the chart with the prior dates data.
I have been looking everywhere with no luck. I am new to Qlik so not sure where to do this, so a setp by step would be nice,
May be like:
=Sum({<Date={"$(=Date(Only(DateField)-1))"} >} Amt) // for date -1
Do you want to have two lines on your Line chart showing today's data and yesterdays data for hours on x axis?
Sudeep, no, I have onle 1 line but I would like to add a second one.
Tresesco, i added COUNT ({<bladate={"$(=Date(Only(bladate)-1))"} >} Folio) as a second expression and nothing shows.
By the way, the demension of the chart is Hour.
Just as a test I made the second expression
SUM(IF(bladate='02/06/2014',[FOLIO]))
If I change the date for bladate it returns nothing on the chart