topic Re: Selection in QlikView

Selection

n1ef5ng1 — Mon, 12 Aug 2013 02:50:45 GMT

Hi gurus,

I have this particular table where user have the option to select which Group_Country field or Group_Region field they would want to look at.

If user select Indonesia, the data will show as of Indoensia perspective

and if user select Asia, the data will show as of Asia perspective.

This is my code

((sum({$<TXIT_Group_Country.Load ={$(=(Group_Country))} >} Transit_TEU) )

Group_Country is a field for user to select the countries from

However, I would want the tableto be dynamic in the sense that it will detect whether user select country or region field before displaying out

I tried methods such as

((sum({$<TXIT_Group_Country.Load ={$(=(Group_Country))},TXIT_Group_Region.Load ={$(=(Group_Region))} >} Transit_TEU) )

((sum({$<TXIT_Group_Country.Load ={$(=(Group_Country))} or TXIT_Group_Region.Load ={$(=(Group_Region))} >} Transit_TEU) )

but it does not work.

Any help, thanks

Re: Selection

tresB — Mon, 12 Aug 2013 04:29:10 GMT

Can this be a simpler solution ?

Create listbox with the following expression : =If(TXIT_Group_Region.Load =Group_Region, TXIT_Group_Region.Load)

And allow user to select from this list box.

Assuming that, TXIT_Group_Region.Load is a superset of Group_Region

Re: Selection

Mon, 12 Aug 2013 06:26:48 GMT

I think you could use the option of conditional visualization of the table. In the design tab, select conditional showing:

Then, in the textbox, you could write down the condition you want to apply. In your particular case, if you want the table to be shown only when one country or one region is selected by the user, it should be something like:

getSelectedCount(Group_Country)=1 or getSelectedCount(Group_Region)=1