Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
marius_larsen
Creator II
Creator II

Calculating expressions HELP

In short; Must get the app to calculate measurements.

We have two fields in the application, "kWh" and "STAND"
kWh stamps a value per hour.
Stand stamps a value per week (7 equal values ​​per day of the week).

I want the application to take first STAND + day usage and create its own state for those days it does not stamp updated status from db.


For example:

Figures from application                     Calculated condition

STAND pr 01.01.2017: 0125000

Consumption 01.01.2017: 100 kWh          Condition: 0125000
Consumption 02.01.2017: 120 kWh          Condition: 0125100
Consumption 03.01.2017: 110 kWh          Condition: 0125220
Consumption 04.01.2017: 0 kWh             Condition: 0125330
Consumption 05.01.2017: 0 kWh             Condition: 0125330
Consumption 06.01.2017: 50 kWh           Condition: 0125330
Consumption 07.01.2017: 75 kWh           Condition: 0125380
Consumption 08.01.2017: 0 kWh             Condition: 0125455

Stand pr 08.07.2017: 0125455

Tips for expressions that can be used?

3 Replies
sunny_talwar

Not entirely sure I understand the requirement... would you be able to share a sample and explain what you need within that sample?

marius_larsen
Creator II
Creator II
Author

I want to calculate a field that gives me the result to the right in the example.

Like, i only have STAND, one unique value pr week. I want to take that number and multiply with daily consumpsion.

sunny_talwar

May be this

Sum(STAND) + RangeSum(Above(Sum(Consumption), 0, RowNo()))