topic Re: Sorting Month Name Wise in QlikView

Sorting Month Name Wise

vijayit43 — Fri, 29 May 2015 11:48:18 GMT

Dear All,

how to sort data month wise(Apr -> Mar) comparison in bellow attached dashboard kindly suggest...

Re: Sorting Month Name Wise

giakoum — Fri, 29 May 2015 11:51:36 GMT

when defining the months use the dual function.

Set Apr as 1

Mar as 2 etc.

Re: Sorting Month Name Wise

anbu1984 — Fri, 29 May 2015 11:59:06 GMT

Check this app

Re: Sorting Month Name Wise

jsanchezh — Fri, 29 May 2015 11:59:33 GMT

Take a look at your "table viewer". You have synthetic keys in your dashboard.

Re: Sorting Month Name Wise

vijayit43 — Fri, 29 May 2015 12:14:19 GMT

For User requirement we use synthetic key.but when Sorting in given chart its not working for me. please resolve

Re: Sorting Month Name Wise

giakoum — Fri, 29 May 2015 12:16:04 GMT

there is no such thing like synthetic key for user requirement. You need to correct your data model

Re: Sorting Month Name Wise

vijayit43 — Sat, 30 May 2015 04:26:45 GMT

Dear ioannis,

We want to need solution for this data model please help and suggest..

Re: Sorting Month Name Wise

giakoum — Tue, 02 Jun 2015 14:42:36 GMT

Your model is a bit of a mess.

1. inlfed-2 is useless, must be dropped

2. Quater in INLFED exists already in your main table as Quarter, so should be dropped. If you need the Q in front (Q1, Q2 etc.) add it in the main table

3. FY should be moved to the sales table as well

If you do the above, no synthetic key will exist

You have many calendar fields in the sales table and in other tables. Consider creating a normal calendar. there are many useful scripts in the community for that :

Understanding the Master Calendar (video)