topic Expression Help in QlikView

Expression Help

Wed, 04 May 2016 11:57:24 GMT

Hi everyone, s

I want to show values for selected month maximum date. I am using using this expression

Sum({<TransactionDate={"$(=Max(TransactionDate))"}>} Sales )

Can someone help me on expression

Thank You

Re: Expression Help

sunny_talwar — Wed, 04 May 2016 11:58:23 GMT

Add date formatting to make it work:

Sum({<TransactionDate={"$(=Date(Max(TransactionDate), 'YourTransactionDateFormatHere'))"}>} Sales)

UPDATE: Max converts TransactionDate into a number and set analysis comparison only works when the formats are same on both side of the equation. So in order to get it to work, you will need to add Date().

Also, make sure that TransactionDate is not a TimeStampField, because if it is, then you might need a more complex expression to get it to work, or you might need to create a only datefield using Date(Floor()) function in the script to perform set analysis.

Re: Expression Help

trdandamudi — Wed, 04 May 2016 12:01:23 GMT

What is your date format ?

Re: Expression Help

swuehl — Wed, 04 May 2016 12:01:28 GMT

As Sunny said, there might be formatting issues, see also

Dates in Set Analysis

But maybe there are some other issues, but it's hard to tell missing any description of what you get and what you expect to get instead from your expression (that would be a basic 'issue reporting').