Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Displaying expressions conditionally in a straight table

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

3 Replies
Nicole-Smith

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

getcurrentfield([Project Analysis with Applicant drill])

Not applicable
Author

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

Nicole-Smith

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