topic Re: Displaying expressions conditionally in a straight table in QlikView

Displaying expressions conditionally in a straight table

Wed, 19 Feb 2014 17:52:14 GMT

Hi everyone,

I have a straight chart with a drill group named (Project Analysis with Applicant drill) containing 5 fields and 10 expressions.

I am adding 4 more expressions which shlould be shown conditionally, my first drill is CU , my next drill is Poject Type, then program and so on

so when drill from CU to Project type I want CU to be shown as one of the expressions, then when I drill from project type to program

I want both CU and Project type to be shown in the expressions which appear as columns in the straight table.

and so on for rest of the drills

Could you please provide inputs on how can get this working, I have used getcurrentfield

for example when I am displaying CU expression I hve given a condition

getcurrentfield('Project Analysis with Applicant drill') <> 'CU'

clearly i am doing something wrong it doesnt seem to work.

Appreciate your inputs

Nicole-Smith — Wed, 19 Feb 2014 17:56:40 GMT

Put the group name in square brackets instead of single quotes:

getcurrentfield([Project Analysis with Applicant drill])

Wed, 19 Feb 2014 18:34:00 GMT

I have tried that before, since it is not a field and because it is a group it gives syntax error

Nicole-Smith — Wed, 19 Feb 2014 18:45:56 GMT

I think it's just a QV bug that it shows as a syntax error, because it works correctly with the brackets.