Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am getting an error as "error in set modifier ad hoc element list"
Can someone help me with what is possibly wrong..
=Num(Sum({<Year ={$(V_Year)}>} [Net Sales]),'#,##0')
I have defined V_Year as a variable with defn Max(Year)
The below is not giving error but displays a zero for previous year
=Num(Sum({<Year ={$(V_Year-1)}>} [Net Sales]),'#,##0')
What do you get when you create a text box with Text:
=V_Year
Modify as below and give a try
=Num(Sum({<Year ={$(=(V_Year)-1)}>} [Net Sales]),'#,##0')
Define Variable v_Year as
=Max(Year)
This is displaying a 0
On Sat, Jun 13, 2015 at 1:13 PM, Satish Kurra <qcwebmaster@qlikview.com>
This is displaying correct value
Thanks.
I had to put the =Sign.
It resolves my problem.
On Sat, Jun 13, 2015 at 1:22 PM, ANTONIO MANCINI <qcwebmaster@qlikview.com>