Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

How to get value of same field from different row in straight table

Hi everybody. I would appreciate some help with this:

I'm trying to get the value of field price in everyrow but from a specific value of field Trade. For example what i'm expecting is column compareprice of the next table. Where compareprice is the value of price where Trade = 'WM_GT'

Captura.PNG

 

The next step is i can choose dynamically the Trade i want compare to every row for anyone combination of Country, Family, description and seller.

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

try this expression:  = sum(total <Description> {<Trade={'WM_GT'}>}Price)

View solution in original post

4 Replies
Highlighted
Creator III
Creator III

try this expression:  = sum(total <Description> {<Trade={'WM_GT'}>}Price)

View solution in original post

Highlighted
Creator III
Creator III

will the comparison always be WM_GT?  wouldnt the user want to select it?  if so create a variable that holds the selected trade (assuming user can only choose 1) with expression =only(Trade) 

then in the price expression:  sum({<Trade=>}Price)
and your compare expression: sum(total <Description> {<Trade={'$(YourVariable)'}>}Price)

Highlighted
Partner
Partner

It Works. Thank you!

Highlighted
Partner
Partner

Yeah. I'll have it in mind. Thanks.