topic Re: Wrong expression in QlikView

Wrong expression

petermoyaert — Mon, 12 Oct 2015 13:44:24 GMT

Anyone an idea what could be wrong in this formula ?

Count ({$<Mid(Magazijnplaats_Artikel,1,1)={'1'}>} %Key_Samniv)

Purpose is to count the number of orderlines (%Key_Samniv) for which articles are placed in room 1 (so for which Magazijnplaats_Artikel starts with number 1).

Peter

Re: Wrong expression

Colin-Albert — Mon, 12 Oct 2015 13:49:53 GMT

A Set expression is based on a field value not an expression.

You could create a new field for Room in your load script and then use that in your set expression rather than using an expression for the room.

In your load script add left(Magazijnplaats_Artikel,1) as Room

Then use this expression in your chart

Count ({$<Room={'1'}>} %Key_Samniv)

Re: Wrong expression

lironbaram — Mon, 12 Oct 2015 13:50:15 GMT

TRY this

Count (if(Mid(Magazijnplaats_Artikel,1,1)='1', %Key_Samniv))

Re: Wrong expression

swuehl — Mon, 12 Oct 2015 13:50:20 GMT

Only field names, no expressions, allowed in set modifiers left from the equal sign.

Create a new field with only the left most character

Count ({$<NewField = {'1'}>} %Key_Samniv)

or try

Count ({$<Magazijnplaats_Artikel = {"=Mid(Magazijnplaats_Artikel,1,1)='1'"}>} %Key_Samniv)

Re: Wrong expression

jonathandienst — Mon, 12 Oct 2015 13:58:31 GMT

I think we are making heavy weather, and you just need:

Count ({$<Magazijnplaats_Artikel={'1*'}>} %Key_Samniv)

ie count where Magazijnplaats_Artikel starts with 1.