Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
0li5a3a
Creator III
Creator 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
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Constantin,

Please try Below:

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


Thanks,

Arvind Patil

0li5a3a
Creator III
Creator III
Author

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

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

kusumanchir
Creator
Creator

Hi Constantin,

Try giving Date as expression in the sort tab.

effinty2112
Master
Master

Hi Constantin,

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

cheers

Andrew

0li5a3a
Creator III
Creator III
Author

Hi,

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

Capture.PNG

0li5a3a
Creator III
Creator III
Author

Capture.PNG

Thanks you all sorted now:)

0li5a3a
Creator III
Creator III
Author

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

tresesco
MVP
MVP

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