topic Re: Sorting Expression Issue in Pivot table in QlikView

Sorting Expression Issue in Pivot table

Anonymous — Fri, 07 Feb 2014 18:42:14 GMT

Hello!

I need help on my sort expressions in my pivot table...

I have a series of Monday dates in weekly buckets for the the current year and with '-' date (those transaction that happened before the current year ).

Category 12/30/13 01/06 /2014 01/13/2014 01/20/2014 02/07/2014 unitl 05/26/2014 -

PO 500 200 300

Order 5 15 20

Sales 200 300 200 200

Invtry 1000

1. How do I make the Category Inventory or those dates that are current like 2/7/2014 to make it to the 1st week bucket (before the 12/30/2013? I don't have a weekly data for the invtry since our source data is live....so it's always current

2. Since I have a null date where the transactions happened before the 2014, I want to exclude these in my pivot chart,

Tks.

Re: Sorting Expression Issue in Pivot table

MK_QSL — Fri, 07 Feb 2014 19:33:51 GMT

Can you upload your sample apps?

Re: Sorting Expression Issue in Pivot table

Christian_Lauritzen — Fri, 07 Feb 2014 19:37:15 GMT

Hi,

With reservation for that I might not completely grasp your challenge, but here is a try;

1. Sort dates in a custom order; Choose sort by expression under the sort tab and create an expression that put Category Inventory or those dates first. Cannot give you more that this as I have no more input. Could you submit your qvw and an excel doc showing your desired outcome?

2. Exclude Null Values - Simply check "Suppress when value is Null" on the Dimensions tab for the Date dimension

Re: Sorting Expression Issue in Pivot table

Anonymous — Fri, 07 Feb 2014 23:21:06 GMT

Hi! Christian,

Question no 2 actually worked ..For question no 1, I actually haven't tried using the sort expression...If you could provide me the formula that woul be better.

Tks.