topic Greater than zero values required. in QlikView

Greater than zero values required.

somacdc — Tue, 05 Nov 2019 13:30:29 GMT

I want to following data

FOLIO_NUMBER_UHR	TOTAL_NO_OF_UNIT_OF_UH
1	166633.7933
2	0.3334
3	0.12
4	133333.3333
5	2500

After applying following condition Folio number 2 and 3 disappear.

ApplyMap('UH_REGISTER_MAPPING', FUND_ID &'-'& FOLIO_NUMBER, 0) >> 0

Re: Greater than zero values required.

jaibau1993 — Tue, 05 Nov 2019 14:10:49 GMT

Hi!

Use ">" instead of ">>" since the second one is a bit-wise operator!

Regards,

Jaime.

Re: Greater than zero values required.

simrankaur — Tue, 05 Nov 2019 14:11:21 GMT

Do you mean greater than 1? Because 2 and 3 are greater than 0, and on applying the condition given by you, they won't disappear. Please mention clearly

Re: Greater than zero values required.

StarinieriG — Tue, 05 Nov 2019 14:13:23 GMT

Hi,

I don't know if it's an error here, but it seems that it's a ">>" instead of ">"