# 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
Did you mean:
Highlighted
Contributor

## Calculate Column

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

Labels (1)

5 Replies
Highlighted
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

## Re: Calculate Column

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