Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Greetings for the day.
I need to make Date filter as single select filter. User do not want to select multiple date. I can see there is an option in Qlikview, that is Always One Selected Value in List Box Property. However I could not see any such kind of option in Qlik sense.
Could you please help me out how to do this in Qlik sense.
Thanks in advance for your help, support , co operation and time...
Thanks,
Sarif
There's no native Always One Selected Value functionality in Qlik Sense yet. You will need to use an extension like Qlik Sense List Box Extension
okk..is this extension is a kind of patch , we need to install?? or any add on to qlik sense? could you please explain a bit? So that I can recommend the same to my customer.
Thanks in advance for your support...
Thanks,
Sarif
1. In Qlik Sense Desktop you need to unzip it and copy the extension into
C:\Users\XXX\Documents\Qlik\Sense\Extensions
Where XXX is your network login name.
See this video as an example:
Qlik Sense - YouTube Extension
2. In Qlik Sense Enterprise you need to import the extension into the server.
Kind Regards,
Dion
Hi Verbeke,
Thanks for your replay...
Is that extension is free or payable? Where to get that extension?
Could you please help me on this??
Thanks a lot for all your co operation and help..
Thanks,
Sarif
Hi Mohammad,
This is possible using extensions. To build one easily, try qWidget extension.
Hi Mohammed,
I used this if(findoneof(concat(fieldName1,'#'),'#')>0,'pls select one value',fieldName1), in the filter obj title section .
In the chart's dimension you can write if($(=count( distinct fieldName1))=1,[$(fieldName1)], 'Please select one')
Best,
Daniel
Daniel,
I am attempting to implement your solution but it is not working as expected. Would you mind posting a small qvf with this implemented so i can research why it is not working for me?
Thanks,
PVS
hi Paul,
hope you will find it useful.
The logic is in Add-ons / Data handling / Calculation condition section.
Created wit v. Sept.
D.
Hi Mohammed,
There is a built in function which gets the number of selected values for a given field. (I could be wrong) but this might be a more efficient calculation over the concat and find one of calculations.
see sample code
if(getselectedcount([DateFieldName])=0,
Sum({<[DateFieldName={'Default'}>}[Field]), //what to do as default (no selection)
if(getselectedcount([DateFieldName])=1, //what to do when one is selected
Sum([Field]),
'Please select one Date' //what do do if more than one is selected
))