topic Re: Conditional expression in QlikView

Conditional expression

Anonymous — Tue, 15 Dec 2015 14:42:41 GMT

Hi guys,

Can anyone explain the following expression please. It's being used as a conditional expression to show fields in a Pivot table.

Thanks

Kieron

Re: Conditional expression

Tue, 15 Dec 2015 16:17:41 GMT

It is trying to enable the dimension field when the dimension name is selected from a list box.

you could write

substringcount(concat(%FieldsFresh,'|'), 'Fresh/Frozen')
and
Len(GetFieldSelections(%FieldsFresh))>0

Re: Conditional expression

Anonymous — Tue, 15 Dec 2015 16:22:14 GMT

Thanks SC

Appreciate your help.

It makes more sense now.

Re: Conditional expression

rubenmarin — Tue, 15 Dec 2015 16:30:52 GMT

To further explain why the inital and final '|'.

Imagine you have this values: "Car" and "Caravan". With these values if the user selects "Caravan" and you don't have the starting and ending '|', the filter expression for "Car" also it's true, as the word "Caravan" contains "Car".

With the starting and ending '|', "|Car|" and "|Caravan|" only will be found when you select that exact values.

Re: Conditional expression

Anonymous — Tue, 15 Dec 2015 16:35:22 GMT

Thanks RubenMarin,

I didn't know that yet.

So the '|' helps to fins only exact matches.

That's good to know

Re: Conditional expression

Tue, 15 Dec 2015 16:39:33 GMT

Ruben you are right. i usually have a associated field in my dimension table (island table) like DimIdentifier field values A, B, C... to avoid those issues .

substringcount(concat({<DimIdentifier ={'A'}>}%FieldsFresh,'|'), 'Fresh/Frozen')
and
Len(GetFieldSelections(%FieldsFresh))>0