Discussion Board for collaboration related to Creating Analytics for QlikView.
My data is as follows:
QVD 1: Sales Order Amount4040 1000
QVD 2:Job No Item Code Type4040 Paper ABC4040 LT-05 XYZ
Note: Although Job No = Sales Order No, it is not specified anywhere.
Now I want following Report output:
Sales Order Amount Color Code4040 1000 05(Take last 2 digits of Item Code where Type = XYZ and Job No = Sales Order)
How do I do this?
Re-posting to avoid any confusion...
QVD 1: Sales_Order Amount4040 1000
QVD 2:Job_No Item_Code Type4040 Paper ABC4040 LT-05 XYZ
Note: Although Job_No = Sales_Order, it is not specified anywhere.
Sales_Order Amount Color_Code4040 1000 05(Take last 2 digits of Item_Code where Type = XYZ and Job_No = Sales_Order)
hi try this
use dimension =if(sales order=job no,sales order ,0) and in expression use Amount and subfield(colourcode,'-',2)
may it helps u