topic Re: how to write script for this query in QlikView

how to write script for this query

Mon, 23 Nov 2015 11:38:34 GMT

how to write script for this query.

If "Security or Cash" column matches Stock List in "Volatilities" then = Stock
Else column name matches Bond list in Volatilities then = Bond
Else = Cash

Re: how to write script for this query

Peter_Cammaert — Mon, 23 Nov 2015 17:01:41 GMT

What's in "Volatilities" and where is it located (in what table)?

Re: how to write script for this query

Mon, 23 Nov 2015 19:10:04 GMT

Volatilities is a table which contains stock list field and bond list field.

and security or cash is a field in another table which contains all stock,bond cash.

Re: how to write script for this query

Anonymous — Mon, 23 Nov 2015 20:02:29 GMT

if you want to do ir in te script do something like this:

Table:

load

if (Security = Stock or Cash = Stock,Stock,

if(Security = Bond or Cash = Bond ,Bond ,Cash)) as YourColumName

sql select * from Volatilities inner join Table on Volatilities.ID=Table.ID;

if you want to keep it in two tables you must have an ID in common and put into a simple table:

if (Security = Stock or Cash = Stock,Stock,

if(Security = Bond or Cash = Bond ,Bond ,Cash))

if it doesn´t work send more information

Re: how to write script for this query

MarcoWedel — Mon, 23 Nov 2015 21:32:04 GMT

‌please post some sample data / application and your expected result.

thanks

regards

Marco