Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get specific value from one Straight Table?

Hello, I've thought about it, and I need help trying to find a way to solve this problem, there must be a simple way to do it, but I'm new to qlikview.

I have the following table:

Dataqlikview.JPG.jpg

I would like to do something like:

If (Select * From StraightTable Where Clasificacion = 'A') = Null Then

     //Do Something

Else

//Do Something

But I don't know how to do it, What I want to do is to check if In my table there are A customers, if there are not, then the customer with the Higher "Venta Neta" would be A, then the next B, I hope you understand and can help me.

Best regards Luis

7 Replies
Not applicable
Author

i am not clearly understand the what exactly you are looking. Please make up some sample data and what you expect desired output ?

Not applicable
Author

There are cases in which 'A' will not be there or 'B', or any of them, so I need to know if they are not there, in order to change the logic, and make them be there.

Not applicable
Author

Hi,

Can u provide sample QVW??

As it is not clear that classification is an expression or dimension.

-Shruti

Clever_Anjos
Employee
Employee

Luis,

You can´t use a value from an object into another object.

If you want to retrieve a specific value from a straight table into a text box for example, you have to make a proper logic (using rank, aggr, etc) in order to calculate that value again

Not applicable
Author

I never said nothing about text boxes, I want to use the value on the same table.

Anonymous
Not applicable
Author

Hi Luis,

do you want to add the logic in same object or different object.like do you want to add extra column to already existed report or what.

Thanks

SHAIK

Not applicable
Author

I want to get a specific value in a specific row number