Disconnecting two listboxes made from the same field.

Wed, 21 Mar 2012 18:29:23 GMT

Hi there,

I have a question that I've been trying to figure out and search for an answer on, and I haven't been able to nail it down yet - so I would love your help.

I have a field called SpotlightName. Now this field is used in certain calculations in a pivot table that I have. See below.

CreativeType	Impressions	Clicks	Conv.	Landing Page
Custom	219,905,317	216,271	19,814	183,525
Flash In-Page	1,446,566,683	1,258,404	99,108	1,051,803
Gif	2,329,004,734	890,899	5,897	877,486
Total	3,995,476,734	2,365,574	124,819	2,112,814

However, a selection in SpotlightName listbox should ONLY affect Conv. and Landing Page calculations (last two columns). I've figured that part out using Set Analysis. Here's the catch: Certain selections in Spotlight Name listbox apply to Conv. column, and other selections in SpotlightName listbox apply to LandingPage column. So in my script, I renamed SpotlightName into two additional fields, "Conv." and "LandingPage" so that I would have TWO list boxes now, with the same values. This is great. Except for when I select anything in the Conv. listbox, it limits everything in my LandingPage list box, which doesn't help me at all.

Bottom line: I need my Conv. listbox only to apply to my Conv. column, and my Landing Page listbox only to apply to my Landing Page column. Remember: Conv. listbox and LandingPage listbox come from the same field - SpotlightName.

Help?

topic Disconnecting two listboxes made from the same field. in QlikView

Disconnecting two listboxes made from the same field.