topic Multiple Conditions on Table in QlikView

Multiple Conditions on Table

Fri, 26 Apr 2013 19:33:56 GMT

Hi i have multiple conditions on a Table; Main object on the table is ArticleNr

i can achieve all conditions however not together;

Logic is as following;

(1)depending on articletype i should load Artikelnr

- if(Article type<> 'r',Artikelnr)

(2) if([Buying Code] <> 1, 8, 9, Artikelnr)

(3) Condition on the Artikeltyp = z;

if(MovementDate > MovementDate -365, Artikeltyp = z)

How can one go about putting all three conditions Together for a straight chart?

i have tried adding the sperate objectsand placing a condition on them without any luck.

Best,

Bradley

nilesh_gangurde — Fri, 26 Apr 2013 19:42:09 GMT

put these three condition in the set analysis syntax.

Sysntax will be as follows.

Sum({<

Article type -= {'r'},

[Buying Code] -= {"1","8","9"},

Artikeltyp = {"z"};

>}Artikelnr)

you can replace the SUM(Artikelnr) .. i just added the same for understanding purpose but you can change it according to requirement.

-Nilesh

Fri, 26 Apr 2013 20:00:38 GMT

Hi Nilesh.

thank you for the advice however, i have the issue of not being able to restrict the values in a table chart.

i have attached the Qvw file to the reply.

Also we need to take the time restriction into account, .condition number (3)

" that if the article numbers with the articletype = Z havent been lifted (movement years) the last year they should not appear in the list as well.