Set Analysis Query with attached qvw / qvd files

[rahulhv1]

Friends, pls. find attached qvw/qvd files as required by most of you.

Problem here is

whereneve is give query

=Sum({<[Fiscal Year]= {$(vcurrentyear)}, FinanceRelease = {'$(VselectDate)'}>} [Capex Item Gross Value])
it works fine, but when i use Less than Sign ( < )  it dosn't work.

e.g.

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

=Sum({<[Fiscal Year]= {$(vcurrentyear)}, FinanceRelease = {"<=$(VselectDate)"}>} [Capex Item Gross Value])
it dosen't work pls. helpl.

[tresesco]

Your FinaceRelease is a text, hence the issue. Convert this into proper date in the script using date#() like:

Load

          Date#(FinaceRelease, 'DD-MM-YYYY') as FinaceRelease

Then it should work.

[mjayachandran]

You can try:

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

or

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

you may use the below tools also:

QlikView-SetAnalysis_Wizard_and_Generator.aspx

[ashfaq_haseeb · Accepted solution]

Hi,

Look at attached application.

Regards

ASHFAQ

[rahulhv1]

Just for an example i have created the qvd using xls file, where as real qvd is created using oracle table (SAP) and in it Finance Release is  already of Date Type

[tresesco]

Reduce and scramble the data and post a sample. Preparing examples for Upload - Reduction and D... | Qlik Community

[rahulhv1]

Thanks Ashfaq, I did a mistake , and it was that i had defined the variable with type date i.e. DD-MM-YYYY where as it should be of Mixed Number format. and it solved the problem. Thanks again