Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to reference the "Current" Column

HI

Is there an easy way to reference the current column

I am using this formula for background colour:

=if(column(2) <= 10, rgb(255,180,180))

An ideal formula would be something like this:

=if(CurrentColumn <= 10, rgb(255,180,180)) . Is there a way to do this?

Thanks

3 Replies
maksim_senin
Partner - Creator III
Partner - Creator III

Hi Andrew,

It seems this is only possible for pivot table with use of ColumnNo(), but who knows, though.

I didn't check how it works in pivot, but if works properly for you and you need a straight table behavior you can just prohibit pivoting (unset Allow Pivoting) and expand the table (set Always Fully Expanded) at the Presentation tab of pivot table properties.

Hope that helps but you need playing with all of these.

Best regards,

Maxim

Stars
Creator
Creator

Did you figure out an answer?  This is my exact question!  7.5 years later....

newuser
Creator II
Creator II

I have the same question! I.e., how to reference the value of the current column in a pivot table because I have conditional logic that needs to execute around it. Has anyone figured out a solution to this?