Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
i am not clearly understand the what exactly you are looking. Please make up some sample data and what you expect desired output ?
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.
Hi,
Can u provide sample QVW??
As it is not clear that classification is an expression or dimension.
-Shruti
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
I never said nothing about text boxes, I want to use the value on the same table.
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
I want to get a specific value in a specific row number