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
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.

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)
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)
Highlighted
Partner

Re: Date problem is Charts

Hi Constantin,

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

Thanks,

Arvind Patil

Highlighted
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
Contributor

Re: Date problem is Charts

Hi Constantin,

Try giving Date as expression in the sort tab.

Highlighted
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
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:)

Highlighted
Contributor III

Re: Date problem is Charts

Thanks you all sorted now:)

Highlighted
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

Re: Date problem is Charts

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