topic Error in set expression in QlikView

Error in set expression

yoganantha321 — Wed, 25 Nov 2020 16:16:04 GMT

I have been using this expression and it is throwing error anybody can help me..........

=Sum({<Num(Month(Date(Date#(Month,'MMM'),'MM')))={">$(=Num(Month(Today())))"}>} Value)

pooja_prabhu_n — Mon, 10 Sep 2018 07:05:45 GMT

Hi,

with reference to your thread expression required

Below expression is working fine for me with the sample data.

for loading script:

Num(Month(Date(Date#(Month,'MMM'),'MM'))) as Temp

Expression:

=Sum({<Temp={"<=$(=Num(Month(Today())))"}>} Value)

You can not use Num(Month(Date(Date#(Month,'MMM'),'MM'))) directly in set analysis.

What is the issue your facing with the below expression:

=Sum({<Temp={"<=$(=Num(Month(Today())))"}>} Value)

Thanks,

Pooja

yoganantha321 — Mon, 10 Sep 2018 07:11:23 GMT

Hi Pooja,

For

Current Month

=Sum({<Temp={">$(=Num(Month(Today())))"}>} Value) the value is 0.08

For future Month

=Sum({<Temp={"<=$(=Num(Month(Today())))"}>} Value) the value is 0.08

both it is showing same value

But i need as current Month is 0.02 and future month 0.06

pooja_prabhu_n — Mon, 10 Sep 2018 07:25:36 GMT

Hi,

That expression is working for me

PFA

Thanks,

Pooja

yoganantha321 — Mon, 10 Sep 2018 08:02:52 GMT

I will check it. Pooja

yoganantha321 — Mon, 10 Sep 2018 08:29:03 GMT

Thanks Pooja.

Its working fine.