topic Re: Qlikview List box issue in QlikView

Qlikview List box issue

jayanttibhe — Sat, 07 Nov 2015 05:49:18 GMT

Hi,

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.

Has anyone got this issue ever? Please let me know about it.

PLEASE FIND the Sample Data where I am getting this issue.

Re: Qlikview List box issue

sunny_talwar — Sat, 07 Nov 2015 12:12:10 GMT

You have used generic names in your post above (A, B, A1, and so on...) but your actual post contains actual field names. What is B and B1, B2 here???

Although I do have a theory that maybe A and B1 do not ever come together. If that's true there is no way you can select A and then B1 because they contradict each's other selection, but I cannot say it confidently before checking it out in your application.

Best,

Sunny

Re: Qlikview List box issue

jayanttibhe — Sat, 07 Nov 2015 12:54:07 GMT

Hi Sunny

Yes there is a valid relation between these list boxes. You can see the

data model and qvw. I tried everything to get rid of this. But its not

working.

Re: Qlikview List box issue

jayanttibhe — Sat, 07 Nov 2015 13:45:30 GMT

Hi Sunny - I have amended the original post and now I made it clear. Field 1 and Field2 are in a way in hierarchy. i.e. when fields of list box A are selected dependent fields from A1 are getting highlighted which is correct. But when I am playing around to select the unselected fileds from list box A again, all the selctions getting wiped out. which should not happen.

Please look into it