Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show selected date and date -1 day on line chart


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,

5 Replies
tresesco
MVP
MVP

May be like:

=Sum({<Date={"$(=Date(Only(DateField)-1))"} >} Amt)    // for date -1

sudeepkm
Specialist III
Specialist III

Do you want to have two lines on your Line chart showing today's data and yesterdays data for hours on  x axis?

Not applicable
Author

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.

Not applicable
Author

By the way, the demension of the chart is Hour.

Not applicable
Author


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