topic How to load this combination? in QlikView

How to load this combination?

Thu, 14 Jan 2016 08:13:33 GMT

How should I do to only load the row´s that have the combination of A4 and 80g?

In this exampel I would like to get row no 1, 2, 3, 4, but not row 5 because row 5 are A4 and 100g.

I did a test with crosstable to get all the "Kolumn"-data to a single field. But from there I got stuck.

tamilarasu — Thu, 14 Jan 2016 08:38:05 GMT

Try,

Test:

LOAD RowNo,

Artikelnr,

Kolumn13,

Kolumn12,

Kolumn11,

Kvantitet

FROM

Paper.xlsx

(ooxml, embedded labels, table is Blad1)

Where Wildmatch(Kolumn13&Kolumn12&Kolumn11,'*A4*80g*','*80g*A4*');

Row 1 is not a combination of A4 and 80g. Let me know.

Thu, 14 Jan 2016 09:37:05 GMT

Thanks so much. And of course you are right in that row 1 is not a correct value