topic Re: Expression to select anything less than field in QlikView

Expression to select anything less than field

Wed, 15 Feb 2017 07:11:05 GMT

Can I write in an expression that selects anything less than the selected date?

So for example

DATE

1st Jan 2017

1st Feb 2017

1st Mar 2017

If I select 1st Mar 2017,

My expression will show data for any dates <= 1st Mar 2017. In this case, it will show 1st Jan 2017, 1st Feb 2017 and 1st Mar 2017.

Look for something like below. But below doesn't work.

Sum({[Date2]*$<BONDMASTER_INSTRUMENT = {'CD', 'CP'}, DATE ={"$(='(<='&[Date2]')')"}>} M_TP_NOMINAL * EXC_RATE)

Anil_Babu_Samineni — Wed, 15 Feb 2017 07:16:39 GMT

You can do like below

Sum({<DATE = {"$('<=' & =Max(DATE))"}>}Measure)

Chanty4u — Wed, 15 Feb 2017 07:18:48 GMT

try like below

Sum({$<Date={"<=$(=Max(Date))"}>} Measure)

sasikanth — Wed, 15 Feb 2017 07:19:40 GMT

Try this

Sum({<Date={"<= $(=max(date))"}>}Sales)

make sure date formats are matching.

sdmech81 — Wed, 15 Feb 2017 07:27:32 GMT

Hi,

I am nt sure about ur data.But it can be done like using modifier like this: {<Date={'<=GetFieldSelections(DAte)'}>}

=SUM({<Date={'<=GetFieldSelections(DAte)'}>}Your_filed_name)

Plss try

sdmech81 — Wed, 15 Feb 2017 07:29:28 GMT

As u want something less than selected date..

Then u use GetFieldSelections to compare as said above

Sachin

shraddha_g — Wed, 15 Feb 2017 07:31:37 GMT

Try

Sum({[Date2]*$<BONDMASTER_INSTRUMENT = {'CD', 'CP'}, DATE ={">=$(=date(max(DATE)))"}>} M_TP_NOMINAL * EXC_RATE)