Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Have you tried creating a Bookmark and setting to "Default".
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
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. "
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
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.
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
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