Discussion board where members can get started with Qlik Sense.
BASED ON THIS TABLE I WANT TO FIND UNIT USAGE BY TYPE AND AMOUNT
THIS RED COLOR RESULT I WANT HAVE FROM THE QLIK SENSE
PLEASE TEACH ME HOW TO THE SCRIPT FUNCTION ABOVE CALCULATION
it's really not clear how do you calculate the bottom table according to the first table
can you explain your calculations logic
otherwise i don't see how you can get help
please refer to the attachment,
I hope this will give you a clear picture.
Unfortunately, it does not. I suggest you explain your requirement in words rather than expecting people to unpack and understand your Excel sheet.
try to use crosstable load
use 2 arguments
lol i also try to explain it but it is **bleep** hard , ok let me try it something i will come back to you guys.