Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Vlookup type functionality

I have a table which looks like the following:

Weight From

Weight

To

Dollar
04$20.38
46$20.38
610$21.48
1012$24.16
1215$26.77
1519$29.29
1920$31.82
2024$34.36
2430$36.87
3035+$38.42

I am taking weight as an input from the user. Now, I want a textbox, that should be able to tell what dollar value applies to that weight (selected by the user).

Would appreciate your help

Thanks,

~H

1 Solution

Accepted Solutions
Not applicable

I got to thinking you may have users want to put decimals in for the weight, so here is an updated file with a round() function on the variable.

View solution in original post

8 Replies
Creator III
Creator III

Hi,

Please find the attached application.

Regards,

Tom

Creator II
Creator II

Hi

PFA

               Hope itz wat u want......

Contributor III
Contributor III

Hi Vaibhav,

Thanks for the reply. But actually I wanted more functionality from that QV. The user can give any values in between the ranges (From & To), and he should be getting the dollar amount associated with the entry. For example, if the user enters 17, he should get the dollar value of $29.29.

Really appreciate your help man.

Regards,

~H

Contributor III
Contributor III

Hi Tom,

Thanks for the response. But I am not trying here to sum up the dollar value. I want the user to plug in any weight, and my QV should provide the dollar amount associated with that weight. Now the weight can equal the 'Weight From' value or be in between 'Weight From' and 'Weight To' values. In either case, my QV should be able to provide the Dollar amount.

Example1: User enters weight=6, QV should provide $21.48

Example2: User enters weight=17, QV should provide $29.29

Appreciate your help

Regards,

~H

Not applicable

Take a look at the attached sheet.  I used intervalmatch to load weights up to 500 (you can adjust the max) and then a variable for the user to input a weight.

Not applicable

I got to thinking you may have users want to put decimals in for the weight, so here is an updated file with a round() function on the variable.

View solution in original post

Contributor III
Contributor III

Thanks Rebeccad, That was super helpful !

Now I need to understand all those crazy commands that you used

Not applicable

No problem - let me know if you have any questions.