topic Show column if data from another table = string in App Development

Show column if data from another table = string

Diinkant — Tue, 18 Oct 2022 21:42:11 GMT

Hi Guys,

I am new the Qlik development so unsure how string expressions work. I am wanting to hide a column in a pivot table if a value in another table = string.

E.g if(brand = 'TIMBERLAND') or i think in Qlik it would be if([brand],'TIMBERLAND')?

Cheers,

Re: Show column if data from another table = string

Diinkant — Tue, 18 Oct 2022 21:41:37 GMT

I should mentioned i have tried if([Brand],'BIRKENSTOCK') and still doesn't work.

Re: Show column if data from another table = string

alinabo12 — Mon, 24 Oct 2022 21:25:37 GMT

I think this is the standard or classical approach to do this. A left join would keep the tuples with 'NA' in the response. Do you have appropriate yearly calendar indexes on your tables?

Re: Show column if data from another table = string

ckarras22 — Sun, 23 Oct 2022 16:59:29 GMT

GetFieldSelections can be used.Do you want to share an example, because the "if a value in another table = string" is very vague?

Re: Show column if data from another table = string

RafaelBarrios — Sun, 23 Oct 2022 17:41:37 GMT

Hi @Diinkant

in qlik the if statement is

If(condition,do something, do something else)

But in this case you only have to use

brand = 'TIMBERLAND'

it will return 0 and hide when is false and return -1 and show when is true.

off course, according to users selections if brand field has more possible values this is going to return false.

and if user select TIMBERLAND Or the others selections reduce this field to this only possible value, it will return true.

hope this helps.

best,

Help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂

Re: Show column if data from another table = string

Diinkant — Mon, 24 Oct 2022 20:01:31 GMT

Legend mate, figured it out last week but this helped heaps. Marked it as the best solution!