topic Re: Set Analysis Query with attached qvw / qvd files in QlikView

Set Analysis Query with attached qvw / qvd files

rahulhv1 — Wed, 20 Aug 2014 05:46:51 GMT

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.

Re: Set Analysis Query with attached qvw / qvd files

tresB — Wed, 20 Aug 2014 05:54:27 GMT

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.

Re: Set Analysis Query with attached qvw / qvd files

mjayachandran — Wed, 20 Aug 2014 07:06:08 GMT

You can try:

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

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

you may use the below tools also:

QlikView-SetAnalysis_Wizard_and_Generator.aspx

Re: Set Analysis Query with attached qvw / qvd files

ashfaq_haseeb — Wed, 20 Aug 2014 08:09:27 GMT

Hi,

Look at attached application.

Regards

ASHFAQ

Re: Set Analysis Query with attached qvw / qvd files

rahulhv1 — Wed, 20 Aug 2014 08:58:47 GMT

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

Re: Set Analysis Query with attached qvw / qvd files

tresB — Wed, 20 Aug 2014 09:04:46 GMT

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

Re: Set Analysis Query with attached qvw / qvd files

rahulhv1 — Wed, 20 Aug 2014 09:07:58 GMT

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