topic Re: How to get specific value from one Straight Table? in Water Cooler

How to get specific value from one Straight Table?

Wed, 15 Jan 2014 03:16:38 GMT

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:

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

Re: How to get specific value from one Straight Table?

Wed, 15 Jan 2014 04:50:39 GMT

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

Re: How to get specific value from one Straight Table?

Wed, 15 Jan 2014 11:50:34 GMT

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.

Re: How to get specific value from one Straight Table?

Wed, 15 Jan 2014 11:57:14 GMT

Hi,

Can u provide sample QVW??

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

-Shruti

Re: How to get specific value from one Straight Table?

Clever_Anjos — Wed, 15 Jan 2014 12:00:04 GMT

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

Re: How to get specific value from one Straight Table?

Wed, 15 Jan 2014 13:00:11 GMT

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

Re: How to get specific value from one Straight Table?

Anonymous — Wed, 15 Jan 2014 13:03:03 GMT

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

Re: How to get specific value from one Straight Table?

Wed, 15 Jan 2014 13:09:41 GMT

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