Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

Ageing Analysis - with bucket logic data source at Ms-Navision 5.00 Version

Dear All,

Does anybody have charts of calculating age wise outstanding of stock (Inventory ) logic from MS Navision System ,

Please share logic how to do this.

-----------------------------------------------------------------------------------------------------------------

Item Name            0-30     31-60    61-90    91-180    >180    Tot Inv Value

-----------------------------------------------------------------------------------------------------------------

Xyz                          10       20          40        7            3                    80

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
1 Reply
Gysbert_Wassenaar

You can use the class function nested in an if statement:

Load

     if(Something>180,'>180', class(Something,30)) as BucketsOfSomething

     FieldX,

     FieldY,

     etc

From ...somewhere...


talk is cheap, supply exceeds demand