topic set analysis to bring one record in QlikView

set analysis to bring one record

renjithpl — Thu, 28 Aug 2014 10:36:17 GMT

Hi All,

I have one account number which has 3 currencies (AUD, NZD and USD), the numbers are converted in AUD.

In my straight table, the currency column showing blank, because it has three currencies..

the only possible option i have is the account number belongs to country "Australia".

I want to show the currency "AUD" instead of blank.

Any idea to bring in this output.

May be some set analysis also will help.

somthing like this

=only({<Country = {$(=max(Country))}>}Currency)

Cheers

Ren

schlettig — Thu, 28 Aug 2014 10:45:34 GMT

you could add another table to the data model for looking up Country to Currency:

load

Country,

Currency as Default_Curreny

that's linked via the country field in you Account Data.

Than you could simply use Default_Currency to be shown.

BR,

Christian

PrashantSangle — Thu, 28 Aug 2014 10:51:30 GMT

Hi,

Create Inline Table and Mention Currency and CountryName in that,

Try something like this,

LOAD * INLINE [

Country,Currency

Australia,AUD

];

Regards

jonathandienst — Thu, 28 Aug 2014 12:00:28 GMT

Its not possible to use a set expression like that. The set expression is evaluated once for the whole chart, and not on a row-by-row basis.

I suggest that you post a sample of your model, so that people can make informed suggestions, rather than guessing.

HTH

Jonathan