Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

how to get max(date) as a dimension

I have table like this

how to plot a chart to get dimension is like max(date) or previous day and I have created measure like how many created and how many submitted

Thanks

Ticket_noDateStatus
11/27/2014Created
11/28/2014Modify
11/29/2014SUBMIT
12/2/2014Closed
21/27/2014Created
21/28/2014Modify
21/29/2014SUBMIT
32/2/2014Created
32/2/2014Modify
38/8/2014SUBMIT
43/1/2014Created
43/1/2014Modify
58/8/2014Created
58/8/2014Modify
510/8/2014SUBMIT
68/9/2014Created
68/9/2014Modify
610/8/2014SUBMIT
611/11/2014  closed
Tags (1)
1 Reply
Not applicable

Re: how to get max(date) as a dimension

Date=Max(dates1) is saying invalid dimension

I have tried Date=today()-1 for previous day but it is not showing the tickets on that day instead showing full count..

I have a master calendar in the data model ... the join is b/w this table->Date and master calendar ->Date