topic Displaying field when max date condition is met in QlikView

Displaying field when max date condition is met

Tue, 02 Dec 2014 14:11:33 GMT

Hi Folks,

I am writing expression to display field when the max date is condition is met .

However it isn't working. Any help would be highly appreciated.

if(RDate=Max(RDate),[VAR_CRNCY_UNITS])

Regards

Varghese

Re: Displaying field when max date condition is met

its_anandrjs — Tue, 02 Dec 2014 14:16:15 GMT

Try to create the variable and then use

Let vMaxVal = Max(RDate);

if( RDate = $(vMaxVal), [VAR_CRNCY_UNITS] )

if(RDate = Maxstring ( RDate ) , [VAR_CRNCY_UNITS])

Regards

Anand

Re: Displaying field when max date condition is met

jerem1234 — Tue, 02 Dec 2014 14:18:03 GMT

Are you making selections on RDate? Try:

if(RDate=Max({1}RDate),[VAR_CRNCY_UNITS])

If this doesn't work, can you explain your situation a bit more? What chart are you using this in? What kind of selections are you making?

Even better, post an example demonstrating your problem if that's possible.

Hope this helps!

Re: Displaying field when max date condition is met

prieper — Tue, 02 Dec 2014 14:21:24 GMT

You need to bring in aggregation of your units, e.g. SUM:

SUM(IF(RDate = MAX(RDate), [Units])

The above may work, if there is just one value available for Units.

HTH Peter

Re: Displaying field when max date condition is met

kushalthakral — Tue, 02 Dec 2014 14:48:51 GMT

Dear Varghese

do you want to make this requirement as conditional one

Regards

Kushal T

Re: Displaying field when max date condition is met

Tue, 02 Dec 2014 14:51:36 GMT

Hi ,

I have and excel sheet with three fields RLIST_Date,FXD_CRNCY_CODE,VAR_CRNCY_UNITS. With RLIST as the Date Dimension and FXD_Crncy_code with values USD,EUR,JPY etc I am trying to build straight table with Currency Code and the Exchange rate as per the data given. The last record that I have is for 24-10-2014 so would want to display the Currency code and the exchange rate for that period and also would want to display it for the previous day so that we show the variance.

Thanks for the all the response.

regards

Varghese

Re: Displaying field when max date condition is met

Tue, 02 Dec 2014 14:56:53 GMT

The requirement is to have straight table displaying the currency and the exchange rate for the max date for data set.