Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
suzel404
Creator
Creator

FieldValue in variables

Hi all,

I have a complex situation to realize.

I have a straight table with range / Start / End / StartEnd / Measure

When I select the range StartEnd I can see Previous StartEnd and Forward StartEnd.

For Example I select StartEnd 10000 - 20000

I get Previous StartEnd 8500-10000

and Forward StartEnd : 20000-30000.

When I do vary my slicer with vStart and vEnd, I would like in straight table :

STARTEND     START    END

8500-10000     8500         vStart

10000-20000   vStart        vEnd

20000-30000   vEnd         30000

So, If I put Distance field, I can see distance and profitability vary between the range StartEnd above and below.

Thank for your help.

1 Solution

Accepted Solutions
suzel404
Creator
Creator
Author

I use avg and Aggr function.

View solution in original post

2 Replies
suzel404
Creator
Creator
Author


Updated data.

suzel404
Creator
Creator
Author

I use avg and Aggr function.