topic Set analysis problem in QlikView

Set analysis problem

Mon, 11 Jun 2012 08:58:53 GMT

Hello everybody, I've a problem with the set analysis: I want to calculate a valor in a graph but it will be between two degrees of a temperature (as an interval) who are in two variables. I've try this :

avg

({$ <temperatura ={">=$(=vchoixtemperaturamin) <=$(=vchoixtemperaturamax)"}>}[moyvalore])

Thank you for your help

Have a nice day

Set analysis problem

Miguel_Angel_Baeyens — Mon, 11 Jun 2012 09:02:21 GMT

Hi,

Syntax seems to be fine. But if that is not working, my guess is that is something likely to do with formats. What do the variables "vchoixtemperaturamin" and "vchoixtemperaturamax" store? How did you create those variables: from the Settings menu or within the script? What is the format of field "temperatura"?

Hope that helps.

Miguel

Set analysis problem

Mon, 11 Jun 2012 09:03:06 GMT

Try

avg

({$ <temperatura ={">=$(=vchoixtemperaturamin)"}, temperature="{ <=$(=vchoixtemperaturamax)"}>}[moyvalore])

Set analysis problem

Mon, 11 Jun 2012 09:20:39 GMT

Hello Miguel,

The variables "vchoixtemperaturamin" and "vchoixtemperaturamax" are create from the Settings menu and represente degrees (who are integer and could be positif or negatif). For example "vchoixtemperaturamin"=-20 and "vchoixtemperaturamax"=10 so I want to have on the graph the degrees who are between -20° and 10°.

And the format of temperatura is an integer positive or negative

Thank you

Re: Set analysis problem

Miguel_Angel_Baeyens — Mon, 11 Jun 2012 09:23:07 GMT

Hi,

Then the following should work:

Avg({< temperatura ={">=$(vchoixtemperaturamin)<=$(vchoixtemperaturamax)"} >} [moyvalore])

Hope that helps.

Miguel

Set analysis problem

Mon, 11 Jun 2012 09:32:09 GMT

And avg({$temperatura={">=$(=vchoixtemperaturamin)"},temperatura={"<=$(=vchoixtemperaturamax)"}>}moyvalor) doesn't work!

Set analysis problem

Mon, 11 Jun 2012 13:03:33 GMT

Thanks a lot Miguel, it works!!!!!

Have a nice day