topic Variable in Set Analysis in QlikView

Variable in Set Analysis

Tue, 19 Apr 2011 14:48:33 GMT

Hi Guys,

I have the following expression: sum({<PayRate={$(V_PayRate)}>Hours). What I want to do is create a between clause. So payrate is between v_payrate and some other variable expression I want to list. Currently it just says = v_payrate

Please help

Thanks,

Byron

Variable in Set Analysis

Miguel_Angel_Baeyens — Tue, 19 Apr 2011 14:55:17 GMT

Hello Byron,

The general rule for syntax is

Sum({< PayRate = {'>=$(vVariableFrom)<=$(vVariableTo)'} >} Hours)

Anyway, check this file to see how set analysis works with date ranges.

Hope that helps.

SV:Variable in Set Analysis

gandalfgray — Tue, 19 Apr 2011 14:59:32 GMT

Hi Byron:

something like this

sum({<PayRate={">=$(vMinPayRate) <=$(vMaxPayRate)"} Hours)

Variable in Set Analysis

Wed, 11 May 2011 13:42:11 GMT

Thanks Gandalf... I see I can only mark 1 as correct now