Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Calculate Column

BASED ON THIS TABLE I WANT TO FIND UNIT USAGE BY  TYPE AND AMOUNT

BILL ACCTYPEUNIT USAGE UNIT PRICE  MIN AMOUNT  MAX AMOUNT 
1900HOUSE HOLD0                 7.00                       7.00                                     7.00
1901HOUSE HOLD1-35                 0.80                       0.80                                   28.00
1902HOUSE HOLD>35                 2.00                       2.00 as per usage amount 
1904INDUSTRIES 0               30.00                     30.00                                   30.00
1905INDUSTRIES 1-35                 2.80                       2.80                                   98.00
1906INDUSTRIES >35                 3.30                       3.30 as per usage amount 

 

THIS RED COLOR  RESULT I WANT HAVE FROM THE QLIK SENSE

BILL ACCTPYE AMOUNT 01-35>35TOTAL USAGE
1900HOUSE HOLD                7.00                      -                              -                                            -                         -  
1901HOUSE HOLD             28.00                      -                       35.00                                          -                  35.00
1902HOUSE HOLD             90.00                      -                       35.00                                   31.00                66.00
1904INDUSTRIES              30.00                      -                              -                                            -                         -  
1905INDUSTRIES              98.00                      -                       35.00                                          -                  35.00
1906INDUSTRIES            150.00                      -                       35.00                                   36.97                71.97

 

PLEASE TEACH ME HOW TO THE SCRIPT FUNCTION ABOVE CALCULATION 

Labels (1)
5 Replies
Highlighted
Partner
Partner

Re: Calculate Column

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  

Highlighted
Contributor
Contributor

Re: Calculate Column

please refer to the attachment,

I hope this will give you a clear picture.

Highlighted

Re: Calculate Column

Unfortunately, it does not. I suggest you explain your requirement in words rather than expecting people to unpack and understand your Excel sheet.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Specialist III
Specialist III

Re: Calculate Column

try to use crosstable load

 

use 2 arguments

Channa
Highlighted
Contributor
Contributor

Re: Calculate Column

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.