topic Translate the SQL statement in to Qlikview expression in QlikView

Translate the SQL statement in to Qlikview expression

Thu, 14 Aug 2014 06:14:12 GMT

Currently im trying to code a expression but I only know how to query it in SQl statement

SQL:

select * from Orders o where o.product_name != MBProductName AND o.transaction_id in ( select m.transaction_id from marketBasket m where m.product_name = MBProductName);

I want to put the results into a chart of table form.

TableForm : And it will do this query when I select the MBProductName.

can anyone help me translate? Thanks in advance

Extra information : The following picture is my Schema for my database

Re: Translate the SQL statement in to Qlikview expression

sujeetsingh — Thu, 14 Aug 2014 06:31:44 GMT

Use nested if to handle this kind of conditional expressions

Re: Translate the SQL statement in to Qlikview expression

Thu, 14 Aug 2014 07:34:16 GMT

Hi, can you teach me how to query it? As im new to qlikview.. thanks in advance

Re: Translate the SQL statement in to Qlikview expression

Mon, 05 Jan 2015 21:12:34 GMT

Depends on what these fields represent and the relation you expect.

Assuming that MBProduct is the same as Product in facts table, you would want an "AND Mode" scenario. To do so, you would need to remove the MBProductGroup as And Mode only takes one table.