topic Re: set analysis with variable in QlikView

set analysis with variable

ilanbaruch — Tue, 06 Dec 2016 11:55:43 GMT

hi all,

i have a variable (vSysHour) with system hour, i want to calculate amount where hour dimension is small or equal to variable value.

tried it like this:

Sum({$<HOUR={"'<='$(vSysHour)"}>}Amount)

it didn't worked..

any ideas?

advanced thanks

shraddha_g — Tue, 06 Dec 2016 12:00:02 GMT

Remove single quotes from expression.

Chanty4u — Tue, 06 Dec 2016 12:02:21 GMT

try without single quote

Sum({$<HOUR={"<=$(vSysHour)"}>}Amount)

sunny_talwar — Tue, 06 Dec 2016 12:02:37 GMT

May be like this:

Sum({$<HOUR={"$(='<=' & vSysHour)"}>}Amount)

Sum({$<HOUR={"$(='<=' & $(vSysHour))"}>}Amount)

jonathandienst — Tue, 06 Dec 2016 12:07:29 GMT

Is vSysHour a numeric or a string? How is it defined? What do =vSysHour and =$(vSysHour) look like in textboxes?

What is HOUR (hours as a numeric, a string time value, a datetime value of hours)?

The answer will be something like:

Sum({$<HOUR={"<=$(vSysHour)"}>}Amount)

Sum({$<HOUR={"<=$(=vSysHour)"}>}Amount)

Sum({$<HOUR={"<=$(=Time(vSysHour))"}>}Amount)

Sum({$<HOUR={"<=$(=Time(Time#(vSysHour, 'xxx'), 'yyy')"}>}Amount)

(replace xxx with format of vSysHour and yyy with format of HOUR