Qliksense Show Column if setting

[davyqliks]

Hi,

I am trying to show a dimension in a table if any filter is made from that dimension.

EG.

City will only show in the table if a city is selected in a map or from a list.

I have created a variable

V.Show.City with a value of 1 and have tried in the show coulmn if FX box to add the following:

=if(v.Show.City=0,1,0)

this hides the city but it does not show when a city is selected.

Any advixe on this would be very helpful.

[AdiPai]

is the v.Show.City working ? did you test it seperatly ?

[davyqliks]

HI,

I didnt, this is new to me and following instruction right now..., what's the best way to test please?

I am getting this in the settings

Thanks so much

[QFabian]

Hi @davyqliks , i think you dont need to put the if , just use the evaluation, like this :

$(v.Show.City)=0

or

v.Show.City=0

[davyqliks]

hi @QFabian 

I really appreciate the help, thanks.

I have this variable:

and have added the suggested to the show column if setting in the dimension for City:

and 

but when i select a city from the map

the citry column does not show in the table..

I think maybe i am missing something.

Thanks in advance again

DQ

[jneppl · Accepted solution]

Hi @davyqliks

you can try to use a function like "GetSelectedCount" that checks if you selected values in a specific field.

Try something like if(GetSelectedCount("Fieldname") > 0, 1, 0) as show condition.

Regards

[davyqliks]

Thank you so much, this is exactly what i was looking for.

DQ