How to modify the model so I can use a temperature field to affect 2 other fields individually?

[#1]

Hi,

I'm creating a dashboard where users can analyze the produced gas and electricity of a specific building. This is based on the outside temperature.

What you'll mainly see are different charts for energytypes such as gas and electricity.

.One requirement is that the user must be able to set a temperature selection for gas and energy individually.

Thus, Temperature slider 1 must only have effect on the gas values. And Temperature slider 2 must only have effect on the electricity values. I can't seem to accomplish this. The problem lies in my current qlikview datamodel.

The data with the temperature and gas/ electricity values comes from an excel sheet, and has the following format:

In Qlikview I applied some modifications to meet certain (other) requirements:

The loaded excelsheet is the "Data"-table in Qlikview.

I splitted the datetime field, So i have only a Date field.

I calculated gasvalues in kWh and MJ also. The same applies to Electricity in MJ.

However, with the current model I'm not able to individually select a temperature range for the gas values and electricity values.

(dont mind the Temperature_electricity and Temperature_Gas fields)

You can also see that I have an inline table "_EnergySelection" which basically holds the energytype (Gas, Electricity) and the possible units of measurement (m3, kWh, MJ). They are in no way coupled to the Data table.

Does anybode know a solution for this?

[Gysbert_Wassenaar · Accepted solution]

This isn't a data model problem imho. If you want to use both sliders at the same time then you will have to use them in different alternate states.