Help with the function

[ecabanas]

I have the following table:

itemid     Cost

99999    9

trans     0

trans     5

123       9

I would like to count the items wich will be "trans" and with 0 cost

Count({<[ITEMID]={'TRANS'}},{[COST]={'0'}>})

Thank's everyone!!

Eduard

[jonathandienst]

Hi

Something like

          Count({<[ITEMID]={'TRANS'}, [COST]={'0'}>} Distinct itemid)

Regards

Jonathan

[ecabanas]

It doesn't work, no results found :s

[jonathandienst]

Qlikview is case sensitive - adjust the expression to show the field names in the correct case.

Jonathan

[ecabanas]

Hi Jonathan,

I know the case sensitive problem, but this is not the problem, all is upper case!!!

and is still without working!!!

thank's for your patience!!!

[jonathandienst]

Eduard

You will need to provide more information - is it returning null, zero or the wrong value? What is the actual expression you tried?

I suggest that you post your model or a sample illsutrating the problem so that it can be looked at in more detail.

Regards

Jonathan

[sivarajs]

Check the attachment

[ecabanas]

See the example attached,

thank you every one!!!

[#9]

Hi,

Use below exp.. it is working for me..

count

({<itemid={'trans'},Cost={0}>}itemid

)

Regards,

Chandra

[ecabanas]

Hi Chandra,

If I only use the first condition it works, but if I add the Cost condittion doesnt work!!! and this combination exists 😉

count ({<itemid={'trans'},Cost={0}>}itemid)

thank's