Default filters issue

[pallavie]

Hi Experts, 

I have created a simple dimension container and I have hidden it. 

Requirement is as i open the app i need the fields (Year, time and Quarter) as default filters. I tried this in two ways.

First :

Sheet action - In this approach filters are getting overwritten.  if apply year and quarter fields there is no overwriting but when i apply another filter (Time) it is getting overwritten.. 

Second :

Following simple dimension (Extension ) i have given 3 filters  in single container. Expected result is coming. However,  the container should not  be visible so I will hide the container. Now when i close the app and open it or refresh it the default filter are not coming. Also when i click on edit sheet and done expected result is coming (without any changes in backend). 

Now what i need is when i open the app default filters should be highlighted. 

Please help. 

Thanks in advance.

Kind regards, 

PV.

[stevejoyce]

Have you tried creating a Bookmark and setting to "Default".

[pallavie]

Hi Steve, 

Thank you for your response. 

If i use the Default bookmark it will remain the same. There wont be any current selections. 

I need current quarter, year and time (Fields).

Regards

PV 

[stevejoyce]

Sorry, I don't understand what you mean "If i use the Default bookmark it will remain the same. There wont be any current selections. "

[pallavie]

Hi Steve, 

For e.g. I have applied (month Jan as field) as default bookmark as the month changes to Feb it would still show Jan as default one. It should show current month always as and it changes. 

Regards

PV

[stevejoyce]

If you make your filter selection using an expression it will apply based on new data set.

For example, this is my data model

test:
load * inline [
value
5
6
7
]
;

in my app, i select in a filter box for the value field, search =value = $(=max(value)).  it will select 7.  create bookmark and set it as default.  if i add 8 to my inline table, the default value selected will be 8 now.

This may be qliksense version dependent, assuming you aren't on too old of a version.

[pallavie]

 Hi Steve, 

Thank you again!

As I apply this expression  = $(=max(Time)).

Getting an error  as  [ Error in Expression =2021/Q3.]

May I know where I am making mistake.

Regards

PV

[pallavie]

Hi Steve, 

Thank you for your help. Much appreciated. 

I have used the following expression to resolve the issue

Time(Field)=Max(Time)

Year(Field)= Max({$<Max{Time}>} Year)

Month(Field)=Max({$<Max{Time}, Max{Year}>} Month}

Using this all three fields got defaulted while using sheet action. 

Thanks again. 

Regards

PV