Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Expression with current/relative position

Hello,

I have a list of 50 measures, I need to change my pivot table, to add the ratio of each of this measure on [NET SALES].

To reference an expression, I can ether use its label ex: =[NET SALES] or its position = Column(1)

I assume I will have to add 50 entries in my pivot table, but I wish they share the same formula (that I can put later as a variable) such as

=Column(CurrentPosition-1)/[NET SALES]

How can I retrieve the current position of an expression?

NET SALES
Cost of Sales
%NET SALES=[Cost of Sales]/[NET SALES]
Warehousing
%NET SALES=[Warehousing]/[NET SALES]
Freight & Delivery
%NET SALES=[Freight & Delivery]/[NET SALES]

...

1 Reply
Not applicable

Re: Expression with current/relative position

can you attache the sample app for the same?

Community Browser