Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
above mentioned set analysis statement is not working. in above example. VselectDate is an input box variable where in user can enter the date as per his/her wish. Please also not that date structure is same i.e. DD-MM-YYYY in variable as well as FinanceRelease field.
If i write
=Sum({<[Fiscal Year]= {$(vcurrentyear)}, FinanceRelease = {'=$(VselectDate)'}>} [Capex Item Gross Value])
it works perfectly fine. but when i enter <= it is not working. Could any one pls. help me
-Rahul
Could you post your sample qvw?
Hi,
Use " double quote instead of ' Single quote and use = to evaluate your variable inside set analysis.
Try
Like this,
=Sum({<[Fiscal Year]= {"$(=vcurrentyear)"}, FinanceRelease = {"<=$(=VselectDate)"}>} [Capex Item Gross Value])
Regards,
Hi,
try below
=Sum({<[Fiscal Year]= {'$=(vcurrentyear)'}, FinanceRelease = {'=$(VselectDate)'}>} [Capex Item Gross Value])
Or post you sample file.
Regards
ASHFAQ
Hi Rahul,
For Numeric Search strings or Text search strings in Set Analysis expressions please use double quotes. Recommed you to go through below link on usage of quotes in QlikView scripting
http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/09/quoteology
Also recommend to go through "Set Analysis" chapter in "QlikView 11 for Developers" by Barry Harmsen & Miguel Garcia
So your expression would be as below
=Sum({<[Fiscal Year]= {$(vcurrentyear)}, FinanceRelease = {"<=$(VselectDate)"}>} [Capex Item Gross Value])
Thanks,
Sri
Its not working. i have tried that too. Pls. find Attached QVW AND QVD FILES.
Its not working. i have tried that too. Pls. find Attached QVW AND QVD FILES.
Its not working. i have tried that too. Pls. find Attached QVW AND QVD FILES.
Hi Rahul,
Try like this
=Sum({<[Fiscal Year]= {'$(=vcurrentyear)'}, FinanceRelease = {'<=$(=VselectDate)'}>} [Capex Item Gross Value])
Regards,
Jagan.
No attachment rahul