Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
constantin_olar
Contributor III

Date problem is Charts

Hi  all,

I have a strange situation where the days are not displayed right.

This is my expression  count({<Date = {"<=$(=DATE(MAX(Date)))>=$(=DATE(MAX(Date)-6))"}>}TICKETID)

This is the Dimension:  Day.

Like you can see I selected the maximum day - 6 to display the last 7  days. As you can see below I suppose to see the day  the data on this logic : 29,30,31,1,2,3,4.

Could please someone advise ?

Capture.PNG

1 Solution

Accepted Solutions
Highlighted

Re: Date problem is Charts

Yes, Make sense. You need to play around with Sort tab? If not, I would ask you to provide sample work file to test

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

19 Replies
Highlighted

Re: Date problem is Charts

Yes, Make sense. You need to play around with Sort tab? If not, I would ask you to provide sample work file to test

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
Partner
Partner

Re: Date problem is Charts

Hi Constantin,

Please try Below:

count({<Date = {'>=$(=DATE(MAX(Date)-6)) <=$(=DATE(MAX(Date)))'}>}TICKETID)


Thanks,

Arvind Patil

Highlighted
constantin_olar
Contributor III

Re: Date problem is Charts

I tied the options from the Sort Tab  but hey don't work.....

I would try to create a simple scenario....

Highlighted
kusumanchir
Contributor

Re: Date problem is Charts

Hi Constantin,

Try giving Date as expression in the sort tab.

Highlighted
effinty2112
Honored Contributor

Re: Date problem is Charts

Hi Constantin,

As Anil suggested the sort tab might have the answer to this. Maybe sort by Expression : Date

cheers

Andrew

Highlighted
constantin_olar
Contributor III

Re: Date problem is Charts

Hi,

I have added now the condition Date like you said and now I have I think the problem sorted:)

Capture.PNG

Highlighted
constantin_olar
Contributor III

Re: Date problem is Charts

Capture.PNG

Thanks you all sorted now:)

Highlighted
constantin_olar
Contributor III

Re: Date problem is Charts

Sorry guys  but after a better check is looking like all the above they are not right. Soo the problem is still open.

Highlighted
MVP
MVP

Re: Date problem is Charts

What is wrong? What are you expecting to see? Could you post a sample qvw?