Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table showing data for five fiscal year.
I want to put condition that by default it should show current fiscal year but user can select any other year from filter panel and than table with reflect that selected year data.
Thanks
Avneet
I had this issue as well and the only way to do so is using book mark or this new feature I found recently.
If you go to your left hand side, under "Fields", search for the field you want to have a default selection. Now when you click over that field, select the first icon (field settings) and select "Always select on value". The only issue is users will not be able to select multiple values but this will give you a default value pre-defined. I have tried using variables and etc but not much luck besides using the bookmark methodology and this one I have mentioned. I'd assume Qlik will have a capability like this in their next release as it is usually a basic capability in most business intelligence suites.
You can create a bookmark with the selection and set as default bookmark that will apply when the user opens the sheet.
Check the help for more details
I had this issue as well and the only way to do so is using book mark or this new feature I found recently.
If you go to your left hand side, under "Fields", search for the field you want to have a default selection. Now when you click over that field, select the first icon (field settings) and select "Always select on value". The only issue is users will not be able to select multiple values but this will give you a default value pre-defined. I have tried using variables and etc but not much luck besides using the bookmark methodology and this one I have mentioned. I'd assume Qlik will have a capability like this in their next release as it is usually a basic capability in most business intelligence suites.