topic Re: Display actual date selection in 'Current Selections' in QlikView

Display actual date selection in 'Current Selections'

Wed, 14 Oct 2015 10:09:07 GMT

Hello,

I have calendar object which allows the user to select a date range. The expressions for 'From' and 'To' are as follows.....

From

=min({1}Date)

=yearend(date(today()))

The problem I having is that when the user selects a date range the display in the 'Current Selections' are shown as numbers. This is a common feature in excel but I can't seem to correct this. See attached for some screen shots.

Any ideas please?

Re: Display actual date selection in 'Current Selections'

Wed, 14 Oct 2015 10:19:25 GMT

try Date(min({1}Date)) & Date(yearend(date(today())))

Re: Display actual date selection in 'Current Selections'

avinashelite — Wed, 14 Oct 2015 10:29:02 GMT

in the calendar your using the variable as the input rite?

Re: Display actual date selection in 'Current Selections'

Wed, 14 Oct 2015 10:39:56 GMT

Thanks but this did not work.

Re: Display actual date selection in 'Current Selections'

Wed, 14 Oct 2015 10:40:56 GMT

Hi Avinash,

Yes, that's right.

Re: Display actual date selection in 'Current Selections'

avinashelite — Wed, 14 Oct 2015 10:45:55 GMT

can you share the app ? it will help us to debug the same

Re: Display actual date selection in 'Current Selections'

tresB — Wed, 14 Oct 2015 10:47:17 GMT

What happens if you use date() with variable sin trigger ->action like:

>=Date($(vMinDate))<=Date($(vMaxDate)) ?

If this doesn't work, try to share a sample qvw.

Re: Display actual date selection in 'Current Selections'

vincent_ardiet — Wed, 14 Oct 2015 11:36:59 GMT

The information is already visible with the listboxes, so why keeping the data in the current selection box?

Rename your field Date by something like %Date and in the script use:

SET HidePrefix='%' ;

So, this field will disapear of the current selection box.

Ok, it's more a workaround than a real solution.

Re: Display actual date selection in 'Current Selections'

Wed, 14 Oct 2015 12:42:31 GMT

I agree, but the business would like to be able to see in the current selection what they have selected.

I can see their point as it is more visually appealing to still see the date range when the calendar box is hidden.

Where should this renaming occur? It is the display in the current selections that I want the dates to show up. In the attached, there appears to be no options to make changes to number format or apply a dimension.

Re: Display actual date selection in 'Current Selections'

demcug82 — Wed, 14 Oct 2015 13:27:44 GMT

Hi Mark,

You have tried to change in the Script the variable DATA in SET DateFormat='DD.MM.YYYY' (from DD/MM/YYYY) ?

I had the same problem but now i have in the Current Selection Dates and Numbers.

But it must convert min and max of variable input (in Date).

Re: Display actual date selection in 'Current Selections'

vincent_ardiet — Wed, 14 Oct 2015 14:29:53 GMT

If it's only to show the selection (and not use the other functions of the current selection box), you can create your own box with a textbox. We have done this for our users creating a sentence in english because they were lost with the standard object.

Re: Display actual date selection in 'Current Selections'

Wed, 14 Oct 2015 14:48:39 GMT

Thanks Vincent, I think that would resolve the issue!

I've used the following expression within a list box and it works well:

='Date range selected: ' & 'From ' &Date(min({1}Date)) & ' To '&Date(yearend(date(today())))

Regards!

Re: Display actual date selection in 'Current Selections'

nagaiank — Wed, 14 Oct 2015 14:54:04 GMT

In the Calendar object, change the format to 'Date' in the Number tab of the properties window to see the date range as dates instead of numbers in the Current Selections box.