Drop Table specific "types"

Mon, 27 Aug 2012 12:30:44 GMT

Hello again,

i have 1 Question and i hope you can help me.

I have a table with prices for different groups, Meaning:

Artikl Cjenik Cijena

1x1 A 10

1x1 D 8

1x1 2580 8

1x1 111106 8

I. Question/Problem:

The column "Cjenik" has A,D,M,T and some numbers(around 20000 different numbers). I want that every number with less then 6 Figures is dropped from the table, but the Letters should also stay. Can somebody please tell me the formula, if there is any?

Thank you very much in advance.

greetings,

Kristian

Re: Drop Table specific "types"

Nicole-Smith — Mon, 27 Aug 2012 12:46:37 GMT

Use the WHERE clause:

WHERE IsNum(CjenikTemp) = 0 OR (IsNum(CjenikTemp) = -1 AND CjenikTemp > 99999);

IsNum(CjenikTemp) = 0 says if it is not a number (i.e. if it is text/letters) keep it

IsNum(CjenikTemp) = -1 AND CjenikTemp > 99999 says if it is a number and it is greater than 99999 (if it is 6 digits) then keep it

(Example is attached.)

topic Re: Drop Table specific "types" in QlikView

Drop Table specific "types"

Re: Drop Table specific "types"