Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jananireddy
Contributor

Launch a sheet with a selection made

Hi Guys,

On a sheet load i need a filter to be set as Account Status = 'A' (In this case only active accounts will show). I could do it with a bookmark, but the client does not want to click anything to achieve this. When they open the sheet the filter should be there. Can i load a sheet with a bookmark enabled?

qq.png

Also I tried using this extension Climber selection bar (GitHub - ClimberAB/ClimberSelectionBar: Qlik Sense Extension. Horizontal selection bar with initial ...) But i am not able to set an initial section to it . A screen shot of  this scenario is pasted below.

qq.png

PS: We are using Qlik sense NOV 2017

11 Replies
agigliotti
Honored Contributor II

Re: Launch a sheet with a selection made

jananireddy
Contributor

Re: Launch a sheet with a selection made

Hi Andera,

I dont want this extension to be visible, Is there a method to hide it

MVP
MVP

Re: Launch a sheet with a selection made

Or add the condition to the expressions:

    =Sum({<[Account Status] = {'A'}>} Amount)

    =Count({<[Account Status] = {'A'}>} Distinct CustomerName)

jananireddy
Contributor

Re: Launch a sheet with a selection made

Hi Jonathan,

Yes this is an easier option ... but the want it as a selection so that they can remove the filter when needed.

jananireddy
Contributor

Re: Launch a sheet with a selection made

I found a smiliar extension too, Qlik sense list box

https://github.com/KumarNatarajan/qliksenselistbox

jananireddy
Contributor

Re: Launch a sheet with a selection made

i am still not able to solve this problem

Does anyone know if you filter to a particular selection and save the qvf, then publish the app. Will it still be the default selection when you open the published app??


I have tried this and it does not work in NOV2017

agigliotti
Honored Contributor II

Re: Launch a sheet with a selection made

sorry i don't understand what's the problem using that extension.

kaanerisen
Contributor III

Re: Launch a sheet with a selection made

Hi,

Without using extension, it is not possible. But maybe you can do it sth like that by using some expressions.

Check the AccountType field if sth is selected. If it is not show account type='A', else show the current selections.

Sum expression : IF(GetSelectedCount([Account Status])>0,Sum(Amt),Sum({<[Account Status]={'A'}>}Amt))

Text Object Expression : 'Account Status : '&IF(GetSelectedCount([Account Status])>0,GetFieldSelections([Account Status]),'A')

Untitled.png

Untitled2.png

You can look into the attached qvf.

Hope it helps.

jananireddy
Contributor

Re: Launch a sheet with a selection made

Hi Andrea, That works perfectly for me, but i want to hide it as it is shown as an empty white space

A screeshot of it has been attached below

Untitled.png

Regards,

Janani