Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm new to Qlik sense, I used to calculate the weight of the product based on two condition.
1. If unit of measure is Pcs then the Weight = Unit.Wt*Quantity
2. If unit of measure is Kg then the Weight = Quantity.
for this scenario, I used formula as below
if(UNIT='PC',SUM(U.Wt*QTY),If(UNIT='KG',SUM(QTY))). the result seems is Ok for the detail records, but it is not appearing for Grand total and appear as Null value.
Attached the screenshot for your review.
I need to know where is the issue which is not showing the Grand total either from my formula or any short of workaround.
Maybe this:
IF(UNIT = 'KG',
Sum( { $< [CUSTINVOICEJOUR.INVOICEDATE.autoCalendar.InYTD]={1},UNIT={'KG'} ,[CUSTINVOICEJOUR.INVOICEDATE.autoCalendar.YearsAgo]={0} > } [CUSTINVOICETRANS.QTY]*FACTOR),
Sum( { $< [CUSTINVOICEJOUR.INVOICEDATE.autoCalendar.InYTD]={1},UNIT={'*'}-{'KG'} ,[CUSTINVOICEJOUR.INVOICEDATE.autoCalendar.YearsAgo]={0} > } [CUSTINVOICETRANS.QTY]))
Not working, the result shows 55.2M instead of 18.2M
post your sample app will make it easier to figure out
Ok, I'll prepare and send you soon.
You can check my expression, There is no Aggregation field in your set.