Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sorting Expression Issue in Pivot table


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.

3 Replies
MK_QSL
MVP
MVP

Can you upload your sample apps?

Christian_Lauritzen
Partner - Creator II
Partner - Creator II

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

Email: christian.lauritzen@b3.se
Anonymous
Not applicable
Author

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.