Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
BASED ON THIS TABLE I WANT TO FIND UNIT USAGE BY TYPE AND AMOUNT
BILL ACC | TYPE | UNIT USAGE | UNIT PRICE | MIN AMOUNT | MAX AMOUNT |
1900 | HOUSE HOLD | 0 | 7.00 | 7.00 | 7.00 |
1901 | HOUSE HOLD | 1-35 | 0.80 | 0.80 | 28.00 |
1902 | HOUSE HOLD | >35 | 2.00 | 2.00 | as per usage amount |
1904 | INDUSTRIES | 0 | 30.00 | 30.00 | 30.00 |
1905 | INDUSTRIES | 1-35 | 2.80 | 2.80 | 98.00 |
1906 | INDUSTRIES | >35 | 3.30 | 3.30 | as per usage amount |
THIS RED COLOR RESULT I WANT HAVE FROM THE QLIK SENSE
BILL ACC | TPYE | AMOUNT | 0 | 1-35 | >35 | TOTAL USAGE |
1900 | HOUSE HOLD | 7.00 | - | - | - | - |
1901 | HOUSE HOLD | 28.00 | - | 35.00 | - | 35.00 |
1902 | HOUSE HOLD | 90.00 | - | 35.00 | 31.00 | 66.00 |
1904 | INDUSTRIES | 30.00 | - | - | - | - |
1905 | INDUSTRIES | 98.00 | - | 35.00 | - | 35.00 |
1906 | INDUSTRIES | 150.00 | - | 35.00 | 36.97 | 71.97 |
PLEASE TEACH ME HOW TO THE SCRIPT FUNCTION ABOVE CALCULATION
hi
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.