topic Re: Issue with sorting in QlikView

Issue with sorting

ferha_jafri — Mon, 12 Aug 2013 06:27:52 GMT

Hello everyone,

I am attaching a documnet in which i want my x axis as 2011 ,2012 ,that then for 2013 i want jan feb mar... but i am not able to get this i am attaching the screenshot ,if anyone knows about it please let me kmow.

Thanks in advance

Ferha Jafri

Re: Issue with sorting

Mon, 12 Aug 2013 06:32:42 GMT

What dimension are you using there? Is that dimension always numeric.

You should use a numeric dimension. You could also create a dimension with dual values:

Dual(String to be shown, numeric value).

Or you could also use an expression to sort the dimension in the graph, the one you have in te sorting tab of the graph.

Re: Issue with sorting

ferha_jafri — Mon, 12 Aug 2013 06:38:46 GMT

I am attaching the documnet please check..

Re: Issue with sorting

Mon, 12 Aug 2013 06:41:02 GMT

Hi ferha_jafri,

I can´t see the document

Re: Issue with sorting

ferha_jafri — Mon, 12 Aug 2013 06:55:17 GMT

just now i attached the documnet did get it?

Re: Issue with sorting

ferha_jafri — Mon, 12 Aug 2013 07:14:10 GMT

Hello Losu,

Now you can see it..

Re: Issue with sorting

Mon, 12 Aug 2013 07:17:17 GMT

As I see, the problem is in the MonthYear2013 field creation:

if([Credit Date Year]='2011',[Credit Date Year],if([Credit Date Year]='2012',[Credit Date Year],if([Credit Date Year]='2013',[Credit Date Month]))) as MonthYear2013

You should creazte a dual field, that way you'll be able to sort it correctly and show it in the graph the way you want. It should be something like:

if([Credit Date Year]='2011', Dual([Credit Date Year], [Credit Date Year]&00),if([Credit Date Year]='2012', Dual([Credit Date Year], [Credit Date Year]&00),if([Credit Date Year]='2013',Dual([Credit Date Month], num(2013 & num([Credit Date Month])))))) as MonthYear2013

What you do here is create a dual field. The dual field has two values, one string that is the one that appears in the grapsh, and one numeric that is the one QV uses for sorting.

Good luck

Re: Issue with sorting

ferha_jafri — Mon, 12 Aug 2013 07:35:56 GMT

My hardluck still can't get what clien is asking for...

Re: Issue with sorting

Mon, 12 Aug 2013 07:44:45 GMT

Hi,

Use this Expression in Sort ( Properties)

WildMatch(MonthYear2013,'2011','2012','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

WildMatch(MonthYear2013,Year(MonthYear2013),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

& Mark as Ascending order......