topic select query in QlikView

select query

manoranjan_d — Wed, 18 Feb 2015 11:43:39 GMT

Hi,

I want to select specific table with specified field. so i used

select * from table name

where field name ="xxx"

but when i check its showing error as "Expected 'Case'" in select line of the macro.

pls help me

prma7799 — Wed, 18 Feb 2015 11:49:06 GMT

Can you post error screen shot?

anbu1984 — Wed, 18 Feb 2015 11:56:25 GMT

Can you post your script

manoranjan_d — Wed, 18 Feb 2015 11:56:40 GMT

i cant share its confidential, can tell me how to select the table and how to use where condition in the macro

anbu1984 — Wed, 18 Feb 2015 12:04:31 GMT

Your Select sql looks ok. Do you use Case statement in Sql?

manoranjan_d — Wed, 18 Feb 2015 12:09:57 GMT

no.

For example you can try the same coding below and click check in the macro it will show error as expected case in the top.

select * from table name

where field name ="xxx"

pls assign ur self a table in qlikview with some value and then create a text box. in the text box action try this above macro coding