topic Dynamic default day selection in QlikView

Dynamic default day selection

nareshthavidishetty — Fri, 19 Feb 2016 08:21:22 GMT

Hi am having day level filter as below

here when ever user open the application by default the day filter is should selected yesterday like today is 19th when the user opens the application the day filter should be 18th ( in green) .

Thanks

Re: Dynamic default day selection

tamilarasu — Fri, 19 Feb 2016 08:24:25 GMT

You can use triggers like below.

Edit: Use expression as =Day(Today())-1, since you want to select yesterday date.

Re: Dynamic default day selection

PrashantSangle — Fri, 19 Feb 2016 08:30:27 GMT

Hi,

It should be

Day(Today()-1) not day(Today())-1

because if Today is 1st day of month then your expression will evaluate 0.

Regards

Re: Dynamic default day selection

tamilarasu — Fri, 19 Feb 2016 08:31:45 GMT

Thank you. It's my mistake.

Re: Dynamic default day selection

jonathandienst — Fri, 19 Feb 2016 08:45:34 GMT

I usually build my apps in a way that does not require an initial selection. So if i have many days in th model, but need a chart/table representing a day, then I would use a set expression to get the most recent date (Max(ReportDate)). if the user selects a date, than the Max(ReportDate) reflects the user's selection.

That way when the user first opens the app, it selects the most recent date (eg yesterday), but the user can select a date or dates from the date selections and it will show the details according to the user's selections.

I define a variable

Set vMaxDate = '=date(Max(ReportDate))';

Then the expression look like:

=Sum({<ReportDate = {'$(vMaxDate)'}>} Amount)

And no initial date selection is required.

I also usually add vMaxDate to the chart/table captions/titles- eg

='Closing balances - ' & vMaxDate

Re: Dynamic default day selection

nareshthavidishetty — Fri, 19 Feb 2016 08:59:47 GMT

Thanks,but my requirement is when ever we open the application the day should selected as yesterday and it should be as below

Re: Dynamic default day selection

tamilarasu — Fri, 19 Feb 2016 09:04:39 GMT

Did you try what I suggested.?

Re: Dynamic default day selection

nareshthavidishetty — Fri, 19 Feb 2016 09:27:15 GMT

sorry i tired that it's not working

Re: Dynamic default day selection

tamilarasu — Fri, 19 Feb 2016 09:36:34 GMT

It's working fine. Check the attachment.

Re: Dynamic default day selection

sasikanth — Fri, 19 Feb 2016 09:40:46 GMT

Check the option always one selected values , if you want to hold the selection for that filter

along with the trigger suggested by Nagaraj

Re: Dynamic default day selection

awhitfield — Fri, 19 Feb 2016 09:57:07 GMT

daft question, but does you qvw have a proper calendar, day, month year etc? Your screen shot only show days as date

Andy

Re: Dynamic default day selection

nareshthavidishetty — Fri, 19 Feb 2016 10:47:50 GMT

Hi ,

Issue resolved as below,

Thanks..