Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

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

Could you post your sample qvw?

Highlighted

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

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.
Highlighted

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

Hi,

try below

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


Or post you sample file.


Regards

ASHFAQ

Highlighted
Not applicable

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

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

Highlighted
Creator II
Creator II

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

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

Highlighted
Creator II
Creator II

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

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

Highlighted
Creator II
Creator II

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

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

Highlighted
MVP & Luminary
MVP & Luminary

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

Hi Rahul,


Try like this


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


Regards,

Jagan.

Highlighted

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

No attachment rahul