topic Get Field Selection - less than in QlikView

Get Field Selection - less than

Wed, 10 Aug 2011 16:24:10 GMT

Hello,

I have the following set analysis, which is showing me inventory for the date i have selected.

How can i modify it to show me the inventory for all dates less than or equal to my selection?

Sum({$<calendar_date={'$(=GetFieldSelections(calendar_date))'}>} on_hand_qty))

rwunderlich — Wed, 10 Aug 2011 18:29:39 GMT

Sum({$<calendar_date={'<=$(=only(calendar_date))'}>} on_hand_qty))

-Rob

jonathandienst — Wed, 10 Aug 2011 18:33:21 GMT

Try this:

Sum({$<calendar_date={"<=$(=GetFieldSelections(calendar_date))"}>} on_hand_qty)

(note the double quotes) But this will fail if you have more than one calendar date selected. You can also try:

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

(assuming calendar_date is in the default date format for you model - otherwise modify the Date() statement)

Hope that helps

Jonathan

sivasiri99 — Fri, 30 Dec 2016 11:25:45 GMT

Hi Jonathan

i would like to have only current selected date and (+5 day and +10 day and +15 day)

example if i had selected :30 dec 2016 in list box in chart i should have 3 Jan 2017 and 8 Jan 2017 and 13 Jan 2017 .

Could you help me out.

sivaram