topic Sort based on FinancialYear and FinancialWeek in QlikView

Sort based on FinancialYear and FinancialWeek

Sat, 09 Mar 2013 07:51:35 GMT

Dear All,

I want to sort the chart by FinancialYear and Financial Week.

I have the dimension FinancialYear &'-'&Financial Week

I tried by using Dual function but I'm not getting it.

kindly find the attachment of Qvw.

i hope someone will help me.

thanks,

Mukram.

Sat, 09 Mar 2013 08:55:33 GMT

Hello Mukram,

You can use Sorting as Expression : FinancialYear+FinancialWeek, that works for me.

PFA picture.

Please let me know if that was helpful or anything else is required.

Thanks,

itsangad