Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Date & Time | Status |
Nov 08 2018 11:59:44 | Not Hungry |
Nov 08 2018 11:59:44 | Not Hungry |
Nov 08 2018 11:59:44 | Not Hungry |
Nov 09 2018 11:59:44 | Not Hungry |
Nov 09 2018 11:59:44 | Not Hungry |
Nov 08 2018 11:59:44 | Not Hungry |
Nov 10 2018 11:59:44 | Not Hungry |
Nov 10 2018 11:59:44 | Not Hungry |
Nov 11 2018 11:59:44 | Not Hungry |
1. How to convert Date & time above to Date ?
2. How to count the status ? and group by date ?
May be use this instead for Date
Date(Floor(TimeStamp#([Date&Time],'MMM DD YYYY hh:mm:ss'))) as myDate,
For second question, try this
Dimension
myDate
Expression
Count(Status)
or
Count(DISTINCT Status)
Here are a few of useful blogs on handling dates correctly.
Why Don't my dates work https://community.qlik.com/t5/Qlik-Design-Blog/Why-don-t-my-dates-work/ba-p/1465849
Get the dates right https://community.qlik.com/t5/Qlik-Design-Blog/Get-the-Dates-Right/ba-p/1476178
Date Fields - Technical briefing https://community.qlik.com/t5/QlikView-Documents/QlikView-Date-fields/ta-p/1484786
i am successful with question no 1 and i use Date(TimeStamp#([Date&Time],'MMM DD YYYY hh:mm:ss')) as myDate,
But still unable to do it for no 2 ?
May be use this instead for Date
Date(Floor(TimeStamp#([Date&Time],'MMM DD YYYY hh:mm:ss'))) as myDate,
For second question, try this
Dimension
myDate
Expression
Count(Status)
or
Count(DISTINCT Status)
Here are a few of useful blogs on handling dates correctly.
Why Don't my dates work https://community.qlik.com/t5/Qlik-Design-Blog/Why-don-t-my-dates-work/ba-p/1465849
Get the dates right https://community.qlik.com/t5/Qlik-Design-Blog/Get-the-Dates-Right/ba-p/1476178
Date Fields - Technical briefing https://community.qlik.com/t5/QlikView-Documents/QlikView-Date-fields/ta-p/1484786
Attached is the screenshot .. the status is not group by date.
I want to count total number under same date in the chart....