Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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:
Hi,
Look at attached application.
Regards
ASHFAQ
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
Reduce and scramble the data and post a sample. Preparing examples for Upload - Reduction and D... | Qlik Community
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