topic select on condition in QlikView

select on condition

antonrus — Thu, 17 Apr 2014 07:01:00 GMT

Hello (sorry do not speak in English)

there is a table

Checknum	Price without discount	Sum of Discounted	discount Amount
122444	10	8	2
122445	15	15	0

It is necessary to select only those checks which have discount and skip the checks that have no discount. And to calculate the amount of revenue these checks.

(If it was possible, I would like to calculate the price and dishes that were in the checks which had a discount but for which the discount is not applied, but it is probably very difficult ..)

Thank you very much for your help!

Re: select on condition

anbu1984 — Thu, 17 Apr 2014 07:07:47 GMT

Use where condition (where discount_Amount > 0)

Re: select on condition

antonrus — Thu, 17 Apr 2014 07:16:00 GMT

and how to write it? I do not understand ..

Re: select on condition

anbu1984 — Thu, 17 Apr 2014 07:21:26 GMT

LOAD *;

SQL SELECT Checknum,Price_without_discount,Sum_of_Discounted, discount_Amount

FROM SCHEMA.TABLE_NAME

WHERE discount_Amount > 0;

Re: select on condition

antonrus — Thu, 17 Apr 2014 07:41:23 GMT

thanks for the report , but I did not change the sql query mou . Rather - myeon table which is - it's not a table , I received a table calculations qlikview.

for example, discount_Amount= Price_without_discount- discount_Amount

Re: select on condition

antonrus — Thu, 17 Apr 2014 07:48:52 GMT

trying to write it something like this:

if ({(sum(sum (PAYSUM))-(sum (PRLISTSUM))={">0"}>})), CHECKNUM

but does not work

Re: select on condition

anbu1984 — Fri, 18 Apr 2014 05:48:23 GMT

Try this expression for your dimension

If(Aggr(Sum([Price without discount]-[Sum of Discounted]),Checknum) > 0,Checknum)