Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 4 list boxes that i have selected.but after selecting values which not associated in any of list box all selection getting cancelled.
but still I want to show all possible associated values for list boxes in that case value also, can you please suggest how to tackle this problem.
Thanks
What you see is QV standard behaviour. Can you elaborate what you expect to see instead?
For example, if I select 'Discount' in list box A, all the other list boxes lose their selections, but they show the possible associated values. So I am not sure what you want to see instead.
You can lock fields that should be possible for your new selections, e.g. Year and Period, to keep the current selections although changing selection in A to an excluded value..
Hi Swehi,
I have a weird situation. I have 2 list boxes where in first box I have 3 fields and 2 fields from this list box are
bifurcated to 2 more fields each to have 4 fields in another list box.
i.e.
A - 1st list box
Example fields : Aa Ab Ac Ad Ae-
A1 - second List Box
Example fields : Aa1 Aa2 Ab1 Ab2 Ac
Note - Sales / profit values of Aa1 + Aa2 = Total of Aa in the First list box. In a way they are in hierarchy and
same with Ab1 and Ab2
If I am selecting any Year and Period - and
when I am selecting A and A1 situation is OK but when I am selecting A and B1 - it automatically wipes out all
the list boxes and selections on the dashboard (here in this case Valid Year and period). I am not getting why
this happening. There are no document / text object level triggers anywhere in the document.
Thanks
Is this the same topic?
Please don't post same request multiple times (with a different user?), it makes it hard to follow a discussion.
I think what you see is by design, QV will always work like this. If you make a selection that renders to an incompatible state (two or more selections are incompatible, no records returned), QV will clear all other selections except the very last: Example: Select Aa and Aa1, then change selection to Ab.
If your new selection is instead compatible with the other selections, like selecting Aa in and Aa1 first, then change to Aa2, it will keep the other selections.
You may ask for the first example, why QV not just clears the selections in the Aa1 and keeps new selection Ab and the selections in other list boxes. I guess it's hard for Qv to tell which selection combination causes the incompatibility, it would need to evaluate all subsets. Maybe that would be possible, but that's not how QV is designed.
If you want to change the design, you need to talk to Qlik / create an idea here in the forum.