Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
rahulhv1
Creator II
Creator II

Set Analysis Issue e.g. =Sum({<[Fiscal Year]= {$(vcurrentyear)}, FinanceRelease = {'<=$(VselectDate)'}>} [Capex Item Gross Value])

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

19 Replies
tresesco
MVP
MVP

Could you post your sample qvw?

PrashantSangle

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,


Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
ashfaq_haseeb
Champion III
Champion III

Hi,

try below

=Sum({<[Fiscal Year]= {'$=(vcurrentyear)'}, FinanceRelease = {'=$(VselectDate)'}>} [Capex Item Gross Value])


Or post you sample file.


Regards

ASHFAQ

Not applicable

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

rahulhv1
Creator II
Creator II
Author

Its not working. i have tried that too. Pls. find Attached QVW AND QVD FILES.

rahulhv1
Creator II
Creator II
Author

Its not working. i have tried that too. Pls. find Attached QVW AND QVD FILES.

rahulhv1
Creator II
Creator II
Author

Its not working. i have tried that too. Pls. find Attached QVW AND QVD FILES.

jagan
Luminary Alumni
Luminary Alumni

Hi Rahul,


Try like this


=Sum({<[Fiscal Year]= {'$(=vcurrentyear)'}, FinanceRelease = {'<=$(=VselectDate)'}>} [Capex Item Gross Value])


Regards,

Jagan.

ashfaq_haseeb
Champion III
Champion III

No attachment rahul