topic Re: Including a variable in Set analysis Expression in QlikView

Including a variable in Set analysis Expression

sudhir0538 — Fri, 08 Jan 2016 07:12:35 GMT

Hi all

Please help me to correct these two not given any result but error set analysis expression.

1)=Avg({<IMQ.Date={$(=vs_Today)},IMQ.Shift={'A'}>}[IMQ.DOLOMITE_Sieve_ -10mm])

2)=Avg({<IMQ.Date={$(vs_Today)},IMQ.Shift={'A'}>}[IMQ.DOLOMITE_Sieve_ -10mm])

Please help me to resolve this.

Variable vs_Today holds today date.

Re: Including a variable in Set analysis Expression

Gysbert_Wassenaar — Fri, 08 Jan 2016 17:02:45 GMT

Try it like this: Avg({<IMQ.Date={$(vs_Today)},IMQ.Shift={'A'}>}[IMQ.DOLOMITE_Sieve_ -10mm])

Re: Including a variable in Set analysis Expression

sudhir0538 — Mon, 18 Jan 2016 14:31:36 GMT

Hai Gysbert!

Thanks for your helpful answer. Both the expressions which I have mentioned are working fine,At the time of posting I didn't have the date data in my source, so it's gave nothing.

Thanks again Gysbert.