topic Re: Sort Problem in QlikView

Sort Problem

Mon, 27 Jul 2015 03:26:00 GMT

Dear Experts,

How I can sort this table in month order(calender order).

Rgds,

Priyantha.

Re: Sort Problem

mohammadkhatimi — Mon, 27 Jul 2015 03:45:36 GMT

Hie...

Write this expreesion in sort tab

=wildmatch(capitalize(only({1}Month)),'APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC','JAN','FEB','MAR')

Regards,

MOhammad

Re: Sort Problem

ecolomer — Mon, 27 Jul 2015 03:56:50 GMT

In Sort tab, write:

=only({1} match(MONTH, 'APR', 'MAY','JUN','JUL','AUG','SEP','OCT') )

Re: Sort Problem

Mon, 27 Jul 2015 04:06:45 GMT

Hi Mohammad,

Really It works............!!!

Thanks lot.

RGDS

Priyantha.

Re: Sort Problem

jagan — Mon, 27 Jul 2015 04:06:55 GMT

Hi,

Try to generate Master fiscal calendar and use that Month field in your chart, no need to this manually in all the charts. This is the best approach.

Check below link for Master calendar generation

Fiscal and Standard Calendar generation

Regards,

Jagan.

Re: Sort Problem

Mon, 27 Jul 2015 04:07:44 GMT

Dear Colomer,

Thanks lot for the help.

RGDS,

Priyantha.

Re: Sort Problem

satishkurra — Mon, 27 Jul 2015 04:52:36 GMT

Also with the above replies and correct answers try this way from back end

Temp:

LOAD * Inline [

Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec ];

Here load the Month column date from source

Now drop the temp table

Drop Table Temp;

This approach will help in giving good performance instead of loading your expression in Presentation layer

Thanks

Satish

Re: Sort Problem

Mon, 27 Jul 2015 08:49:54 GMT

Dear Satish,

Definitely I will try your method.

Rgds,

Priyantha.

Re: Sort Problem

Mon, 27 Jul 2015 08:50:47 GMT

Dear Jagan,

Definitely I will try your method.

Rgds,

Priyantha.