topic Re: Sorting in the chart is not working in Pixel Perfect in Qlik NPrinting

Sorting in the chart is not working in Pixel Perfect

Arjun8443 — Thu, 01 Jul 2021 08:39:18 GMT

Hello

Unable to sort the date, the issue is in my report I am using the many charts and in that all other charts are sorted properly some charts date not sorted correct.

Not Sorted Date

but I am using the same data source for the below chart its sorted well

sorted date

and also I have set the sorting based on the Argument

In Qliksense straight table its well sorted,

I am not sure why its not sorting for above chart

Please help

Re: Sorting in the chart is not working in Pixel Perfect

Lech_Miszkiewicz — Thu, 01 Jul 2021 10:38:01 GMT

Sorry - when I am looking at your chart images they both seem to be sorted based on US date format correctly.

Can you help me where is it not sorted properly? So far everything looks ok.

Re: Sorting in the chart is not working in Pixel Perfect

Arjun8443 — Thu, 01 Jul 2021 10:41:26 GMT

on the first chart its not sorted in chronological order

after march and then I see 03/9/2021 and then I have this feb date (2/11/2021)

Re: Sorting in the chart is not working in Pixel Perfect

Lech_Miszkiewicz — Thu, 01 Jul 2021 10:55:35 GMT

I see...Shouldn't your argument scale type be DateTime?

Re: Sorting in the chart is not working in Pixel Perfect

Arjun8443 — Thu, 01 Jul 2021 11:02:24 GMT

But when I tried to change the scale to date time its not allowing

Re: Sorting in the chart is not working in Pixel Perfect

Lech_Miszkiewicz — Thu, 01 Jul 2021 11:04:37 GMT

What about Numerical?

I would also check how the date field is created in Qlik Sense. What is the field tag in data model? Is it text field, or dual or numericalel,date, integer.....

Re: Sorting in the chart is not working in Pixel Perfect

Arjun8443 — Thu, 01 Jul 2021 11:11:55 GMT

Its a date formatted

and also I used the same datefield for other chart its seems good

Re: Sorting in the chart is not working in Pixel Perfect

Lech_Miszkiewicz — Thu, 01 Jul 2021 11:19:53 GMT

It is not Date. You can see that it is left alligned which indicates that it is a TEXT!

The field type I was talking about you can see in Data Model Viewer when selecting field - there you will be able to see field type.

@Ruggero_Piccoli - do you have any insights on what type of data is supported as argument (DateTime) ?

Re: Sorting in the chart is not working in Pixel Perfect

Arjun8443 — Thu, 01 Jul 2021 11:35:10 GMT

it is a date format but as you see below chart , the same date I am using but gets sorted perfectly

Re: Sorting in the chart is not working in Pixel Perfect

Lech_Miszkiewicz — Thu, 01 Jul 2021 11:42:34 GMT

This is confusing. In model you showed me Date and on chart you use EntryDate dimension. Is this the same field?
I dont know what else i can suggest…

like i mentioned in previous post you may try to use numerical sorting which in case of date is used typically in qlik sense to allow for proper date sorting…

Re: Sorting in the chart is not working in Pixel Perfect

Arjun8443 — Thu, 01 Jul 2021 11:53:13 GMT

Entry Date is just a chart title I created, but the field is date I will
try to check about the DateTime

Re: Sorting in the chart is not working in Pixel Perfect

Arjun8443 — Thu, 01 Jul 2021 11:53:18 GMT

In the chart I have named is as EntryDate ( chart title ) but I will test as you mentioned

Re: Sorting in the chart is not working in Pixel Perfect

Arjun8443 — Thu, 01 Jul 2021 12:41:10 GMT

I managed to get the date Time in the chart

now its sorted chronologically but how to I show series of dates below the bar ( Now I am seeing only 5 dates)

I am not able to find the option to show series of dates

Re: Sorting in the chart is not working in Pixel Perfect

Lech_Miszkiewicz — Thu, 01 Jul 2021 12:46:30 GMT

Have you checked under the axis properties?

i am not sure if it is there as i cannot check it now, but this is a place where i would look for it

Re: Sorting in the chart is not working in Pixel Perfect

Arjun8443 — Thu, 01 Jul 2021 14:02:42 GMT

Thank you for you help

Re: Sorting in the chart is not working in Pixel Perfect

Ruggero_Piccoli — Fri, 02 Jul 2021 11:06:10 GMT

Hi @Lech_Miszkiewicz ,

I did some tests with my installation and when I select a field that is DateTime that option is automatically selected in the PixelPerfect chart. So I think that it becomes red when the selected field is not read ad dateTime by the PixelPerfect editor.

Best Regards,

Ruggero