topic What is the correct syntax in QlikView

What is the correct syntax

HariIyer — Wed, 25 Aug 2021 21:29:10 GMT

A little help please with Dates!!

I have a date formatted variable: 'vReport_Date' ( MM/DD/YYYY)and I am trying to bring in selected records for a particular year

this is what I have and prouces '0' results:How should I correct this?

[Transactions.Txn Date]={"$('>=' & $(=Date(vReport_Date-365) & '<=' & $(=Date(Report_Date))))"}

However ; this produces correct results:[Transactions.Txn Date]={"$(= '>=' & '01/01/2025' & '<=' & '12/31/2025')"}

thanks in advanc

best regards

Hari

Re: What is the correct syntax

MayilVahanan — Thu, 26 Aug 2021 01:14:45 GMT

Try like below

[Transactions.Txn Date]={">=$(=Date(vReport_Date-365))<=$(=Date(Report_Date))"}

Re: What is the correct syntax

Lakin — Thu, 26 Aug 2021 05:15:35 GMT

Syntax states the rules for using words, phrases, clauses and punctuation, specifically to form sentences. Correct syntax examples include word choice, matching number and tense, and placing words and MyBalanceNow phrases in the right order.

Re: What is the correct syntax

HariIyer — Thu, 26 Aug 2021 13:14:40 GMT

Mayil,

Thanks for the reply ,but It does not produce any results. I should have mentioned that I am using this in Quickbooks Enterprise (QBAR) - Advanced reporting application which is based on the QLIK engine( 'Intuit' licenced the engine for its use in Quickbooks Enterprise -Advanced reporting). Perhaps the syntax in there is slightly different. Any other suggestions?

Best regards

Hari

Re: What is the correct syntax

jasminlannister — Mon, 29 Nov 2021 13:35:47 GMT

Hi, in order to make the variable work, you need to 'activate' them with a $ sign.

tescoviews

Try the following::

Sum({$<[Transactions.Txn Date]={">=$(CurrMinDate)<=$(CurrMaxDate)"}>}[Transactions.Amount With Sign])