topic Re: Default in QlikView

Default

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

Gysbert Wassenaar

i have field quarter

2017Q1

2017Q2

2017Q3

2017Q4

2018Q1

2018Q2

2018Q3

so i want to be default selection with last four quarters when ever i open the dashboard.

Re: Default

Anil_Babu_Samineni — Wed, 05 Sep 2018 11:16:14 GMT

Do you have date field? If so, I suggest you to work from Date field like for OnOpen Trigger using DateField is the field and String like below.

='>=' & Date(QuarterStart(Max(DateField), -4)) & '<=' & Date(Max(DateField))

Re: Default

soniasweety — Wed, 05 Sep 2018 11:20:04 GMT

i dont have date field anil. from database directly getting that field.

Re: Default

marcus_sommer — Wed, 05 Sep 2018 11:35:31 GMT

I assume that your Quarter is a string what meant that there is no easy way to calculate with the values but you could create a date from it, for example with something like: date(date#('2017Q1', 'YYYYQM'))

But easier in your case should be to load your data sorted to Quarter and using:

autonumber(Quarter) as QNumber

and then your condition within the trigger could look like

= '>=' & max(QNumber) - 4

- Marcus

Re: Default

soniasweety — Wed, 05 Sep 2018 11:47:35 GMT

its not working

marcus_sommer

i have created autonumber(Quarter) as QNumber

and in onopen trigger

field= QNumber

string=

= '>=' & max(QNumber) - 4

but its not giving the result.

Re: Default

soniasweety — Wed, 05 Sep 2018 11:56:10 GMT

ATTACHING THE SAMPLE

Re: Default

tresB — Wed, 05 Sep 2018 12:07:04 GMT

I guess, simple rank() could work here.

Search String ='=Rank(Quarter)<5'

try the same search string in OnOpen trigger.

Re: Default

marcus_sommer — Wed, 05 Sep 2018 12:14:41 GMT

Does it select the wrong quarters or happens nothing? The autonumber-approach worked only if the data are loaded with a proper sorting. Further worked with only one parameter if it's used once - by applying it multiple times a second parameter must be specified.

Whereby I think the solution from Tresesco is even more easier.

- Marcus

Re: Default

soniasweety — Wed, 05 Sep 2018 12:18:39 GMT

yes tresesco solution is working perfect.

but one doubt i have here i have given background color for dimension but it is not taking all values why this is happening?