topic Re: Date problem is Charts in QlikView

Date problem is Charts

0li5a3a — Fri, 04 Aug 2017 09:03:26 GMT

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 ?

Re: Date problem is Charts

Anil_Babu_Samineni — Fri, 04 Aug 2017 09:07:27 GMT

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

Re: Date problem is Charts

arvind_patil — Fri, 04 Aug 2017 09:08:18 GMT

Hi Constantin,

Please try Below:

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

Thanks,

Arvind Patil

Re: Date problem is Charts

0li5a3a — Fri, 04 Aug 2017 09:09:42 GMT

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

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

Re: Date problem is Charts

kusumanchir — Fri, 04 Aug 2017 09:11:58 GMT

Hi Constantin,

Try giving Date as expression in the sort tab.

Re: Date problem is Charts

effinty2112 — Fri, 04 Aug 2017 09:14:42 GMT

Hi Constantin,

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

cheers

Andrew

Re: Date problem is Charts

0li5a3a — Fri, 04 Aug 2017 09:23:13 GMT

Hi,

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

Re: Date problem is Charts

0li5a3a — Fri, 04 Aug 2017 09:24:54 GMT

Thanks you all sorted now:)

Re: Date problem is Charts

0li5a3a — Fri, 04 Aug 2017 11:04:27 GMT

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

Re: Date problem is Charts

tresB — Fri, 04 Aug 2017 11:13:39 GMT

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

Re: Date problem is Charts

0li5a3a — Fri, 04 Aug 2017 11:16:55 GMT

Hi ,

I checked again and now I can see that using the Date like expression in the Sort tab is not right.

I have 4 qvds which contains 4 types of tickets but the data format is the same and I can see now something like this

As you can see I use the same data only the ticket is different:

expressions:

count({$<OP.Date = {"<=$(=DATE(MAX(OP.Date)))>=$(=DATE(MAX(OP.Date)-6))"}>}OP_TICKETID)

count({<WO_Date = {"<=$(=DATE(MAX(WO.Date)))>=$(=DATE(MAX(WO.Date)-6))"}>}WO_TICKETID)

count({<CR.Date = {"<=$(=DATE(MAX(CR.Date)))>=$(=DATE(MAX(CR.Date)-6))"}>}CR_TICKETID)

count({<PB.Date = {"<=$(=DATE(MAX(PB.Date)))>=$(=DATE(MAX(PB.Date)-6))"}>}PB_TICKETID)

Dimenssions:

OP.Day

WO.Day

CR.Day

PB.Day

if I uncheck all the Sorting I can see now I can see the right data for the first OP.Tickets but I can't to see for all the rest.

Someone can advise ?

Re: Date problem is Charts

0li5a3a — Fri, 04 Aug 2017 11:18:09 GMT

I responded above to Anil. I would try to create some sample qvw.

Re: Date problem is Charts

kusumanchir — Fri, 04 Aug 2017 11:27:14 GMT

Hi,

So for the first chart are you using OP.Date as an expression under the sort tab ?

If so, make the same changes for other charts. Actually you need to use the Date column which you are using in your expression.

Use below Date columns as expression under Sort tab,

chart 1 - OP.Date

chart 2 - WO.Date

Chart 3 - CR.Date

Chart 4 - PB.Date

Re: Date problem is Charts

0li5a3a — Fri, 04 Aug 2017 11:53:24 GMT

I added some sample test data please find above the attached files.

Re: Date problem is Charts

0li5a3a — Fri, 04 Aug 2017 11:55:49 GMT

I tried all already... I just attached some sample data.

The thing is I need to display all the tickets even if we have days with no tickets.

Let say today is 04/08/2017 I want to display all the OP from 29,30,31,1,2,3,4

Re: Date problem is Charts

0li5a3a — Fri, 04 Aug 2017 12:49:20 GMT

Hi all,

Thanks you for your support. I think I found the solution.... I need to add the MAX(OP_Date) In the Sort Tab.. If I don't add the Max function the system would not pick up the right order.

Regards,

Re: Date problem is Charts

kusumanchir — Fri, 04 Aug 2017 13:25:03 GMT

Hi Constantin,

Actually I have personal edition, could you please send me the script and excel if possible.

Re: Date problem is Charts

0li5a3a — Fri, 04 Aug 2017 14:20:08 GMT

I managed to solve the problem adding Max function into the sort expression.

Max(OP_Date)

Re: Date problem is Charts

Anil_Babu_Samineni — Fri, 04 Aug 2017 14:22:13 GMT

Cool, Flag your response as correct answer

Re: Date problem is Charts

0li5a3a — Mon, 07 Aug 2017 09:00:05 GMT

I would flag yours because you drived me on the right direction. Thanks