topic Re: Default filter value and conditional selection in QlikView

Default filter value and conditional selection

safik003 — Wed, 07 Nov 2018 19:44:58 GMT

I have four list boxes say date, insurance no,claim no and bill no. By default latest date will be shown.accordingly latest insurance no of that date,claim no and bill no will be selected automatically.only one value can be selected from each of these filters.one more condition,if I select insurance no then only I will be able to select claim no and if select claim no then only I will be able to select bill no respectively. Accordingly relevant data will be shown in the pivot table. Is it possible to build? Many thanks in advance.

Re: Default filter value and conditional selection

tharanikannan — Thu, 08 Nov 2018 07:39:54 GMT

Hi,

Please share a sample qvw to work on. It seems to be possible. I will give a try .

Thanks,

Tharani.

Re: Default filter value and conditional selection

safik003 — Thu, 08 Nov 2018 09:38:55 GMT

Hi Tharani!

I'll attach one sample file for your reference soon.

Thanks,

Safik

Re: Default filter value and conditional selection

Anil_Babu_Samineni — Fri, 09 Nov 2018 10:14:24 GMT

Did you missed that?

Re: Default filter value and conditional selection

safik003 — Wed, 14 Nov 2018 19:12:29 GMT

Hi,

Instead of date, insurance no,claim no and bill no fields I have these four list boxes but the above condition remains same. Can you please help me out? PFA the file. Many thanks.

Sorry for the late reply

Re: Default filter value and conditional selection

sunny_talwar — Thu, 15 Nov 2018 18:10:54 GMT

I am not sure I follow what you are looking to do here? Can you explain using an example from the sample attached

Re: Default filter value and conditional selection

safik003 — Thu, 15 Nov 2018 18:50:14 GMT

Let me put you this way, I have four filters(list box) Sales Date,Product No, Serial No,Warranty Period In Year in my dashboard. Mapping between these filters are like this A Sales Date can have many Product No, Product No can have many Serial No,and a Serial No can have many Warranty Period though the mapping doesn't make sense still take it for just an example. By default I need to select maximum Sales Date,Minimum Product No for that maximum Sales Date,Minimum Serial No for selected Product No and for that Serial No minimum Warranty Period will be shown by default. It goes something like this---

Maximum Sales Date ------> minimum Product No -------> minimum Serial No--------> minimum Warranty Period.

I have tried this using OnActiveSheet trigger but only the first two filters are getting selected.Rest are not getting selected on server.Trigger can be used on OnOpen or on PostReload. Hope you got me.

Re: Default filter value and conditional selection

safik003 — Thu, 15 Nov 2018 19:04:48 GMT

forgot to mention, only one value can be selected from each of these filters like When default values are cleared and If we try to select more than one value it will restrict me to select multiple values from each filter. I have tried this by checking "only one value selected" from the list box properties but not getting satisfied result.

Re: Default filter value and conditional selection

sunny_talwar — Thu, 15 Nov 2018 20:04:17 GMT

May be like the attached

Re: Default filter value and conditional selection

safik003 — Thu, 15 Nov 2018 20:16:40 GMT

I can't open the file. Can you please send me a personal edition one?Thanks.

Re: Default filter value and conditional selection

sunny_talwar — Thu, 15 Nov 2018 20:19:19 GMT

Well there are no personal edition qvw files... there is a personal edition vs licensed version of QlikView desktop client. I think you are using personal edition QlikView desktop and have exhausted your 4 times recovery. Unfortunately, you will not be able to open this unless you get a licensed version of QlikView.

Re: Default filter value and conditional selection

safik003 — Thu, 15 Nov 2018 20:24:07 GMT

Thanks for the info.