topic Re: Show date if inside selected date range? in QlikView

Show date if inside selected date range?

Wed, 08 Oct 2014 09:23:09 GMT

Hi! I hae this colomn first_order_date and want to show it in my result table only if it's inside the selected date range.

For example:

product a s first_order_date = 2014-02-12

my selection of dates is 2014-01-01 to 2014-03-01

then i want to show first_order_date

but if my selection of dates is 2014-04-01 to 2014-05-01 i dont want it to show.

any ideas?

antoniotiman — Wed, 08 Oct 2014 09:28:50 GMT

Hi Rickard,

Your selection date is from List Box or Date_Start and Date_End ?

Wed, 08 Oct 2014 09:37:45 GMT

Its actually from 3 listboxes, using year, month, day,

mjayachandran — Wed, 08 Oct 2014 09:42:34 GMT

Just Create two new variables… like "vStartDate" and "vEndDate"

then go to Settings –>> 'Document Properties' –>> 'Triggers' --> 'Variable Event Triggers'

Select vStartDate -- > OnChange Add Action --> Add --> Select in Field

Field = "Your Date field"

Search String = ='>='&vStartDate & '<=' & vEndDate

same for 'vEndDate'.

In Input Box , add these two variables, Go to number tab and make sure that the formatting of vStartDate and vEndDate is same as your Date Field….

jonathandienst — Wed, 08 Oct 2014 09:43:24 GMT

You may be able to use something like:

=Sum({<first_order_date = P(day)>} value)

HTH

Jonathan

tresB — Wed, 08 Oct 2014 09:44:09 GMT

How are the date field related? It would be easier to help if you could create a sample qvw and share.

antoniotiman — Wed, 08 Oct 2014 09:52:25 GMT

See attachment.

Thet is a starting point.