topic Re: List Box conditioning in QlikView

List Box conditioning

jjking58 — Tue, 13 Dec 2016 19:42:29 GMT

Can someone explain how to condition a list box from showing amounts that are zero or null.

I coded the following under the General-->Field --> Expression

=if(aggr(sum({<IDPAGR={'PART','MECH','CAFE','OCSE','COOL'},NOAGRP-={'INTR'}>}Amount)+

sum({<IDPAGR={'EQUP'},OrderType-={'TI'},NOAGRP-={'INTR'}>}Amount)+

sum({<IDPAGR={'LABO','INST'},OrderType-={'SR'},NOAGRP-={'INTR'}>}Amount),NANAME)<=0,0,

NANAME&' '&sum({<IDPAGR={'PART','MECH','CAFE','OCSE','COOL'},NOAGRP-={'INTR'}>}Amount)+

sum({<IDPAGR={'EQUP'},OrderType-={'TI'},NOAGRP-={'INTR'}>}Amount)+

sum({<IDPAGR={'LABO','INST'},OrderType-={'SR'},NOAGRP-={'INTR'}>}Amount))

I would like the NANAME(customer) field along with the Amount to show if the Amount is not zero or null

Also do i need anything under the expression tab?

My result looks like this

Thanks in advance

Jim

Re: List Box conditioning

sunny_talwar — Tue, 13 Dec 2016 20:06:05 GMT

Use this on the General tab

Aggr(Only({1<NANAME = {"=Sum({<IDPAGR={'PART','MECH','CAFE','OCSE','COOL'},NOAGRP-={'INTR'}>}Amount) + Sum({<IDPAGR={'EQUP'},OrderType-={'TI'},NOAGRP-={'INTR'}>}Amount) + Sum({<IDPAGR={'LABO','INST'},OrderType-={'SR'},NOAGRP-={'INTR'}>}Amount) > 0"} NANAME), NANAME)

and then on the expression tab, try this

=Sum({<IDPAGR={'PART','MECH','CAFE','OCSE','COOL'},NOAGRP-={'INTR'}>}Amount) + Sum({<IDPAGR={'EQUP'},OrderType-={'TI'},NOAGRP-={'INTR'}>}Amount) + Sum({<IDPAGR={'LABO','INST'},OrderType-={'SR'},NOAGRP-={'INTR'}>}Amount)

Re: List Box conditioning

jjking58 — Tue, 13 Dec 2016 20:13:50 GMT

Sunny

Now only the header of the list box shows.

Re: List Box conditioning

sunny_talwar — Tue, 13 Dec 2016 20:15:55 GMT

Keeping the Sum() aside some a little bit, this as your list box expression on the general tab doesn't work?

Aggr(Only({1<NANAME = {"=Sum({<IDPAGR={'PART','MECH','CAFE','OCSE','COOL'}, NOAGRP-={'INTR'}>} Amount) + Sum({<IDPAGR={'EQUP'}, OrderType-={'TI'}, NOAGRP-={'INTR'}>} Amount) +Sum({<IDPAGR={'LABO','INST'}, OrderType-={'SR'}, NOAGRP-={'INTR'}>} Amount) > 0"} NANAME), NANAME)

Re: List Box conditioning

jjking58 — Tue, 13 Dec 2016 20:25:16 GMT

Sorry i'm not sure what your asking. This is were i put the code and the result is on the right

Re: List Box conditioning

sunny_talwar — Tue, 13 Dec 2016 20:29:05 GMT

Sorry, I missed the ending part of the set analysis (>})... Try this:

Aggr(Only({1<NANAME = {"=Sum({<IDPAGR={'PART','MECH','CAFE','OCSE','COOL'}, NOAGRP-={'INTR'}>} Amount) + Sum({<IDPAGR={'EQUP'}, OrderType-={'TI'}, NOAGRP-={'INTR'}>} Amount) +Sum({<IDPAGR={'LABO','INST'}, OrderType-={'SR'}, NOAGRP-={'INTR'}>} Amount) > 0"}>} NANAME), NANAME)

Re: List Box conditioning

jjking58 — Tue, 13 Dec 2016 20:31:31 GMT

That was it.

Thanks for your help it was greatly appreciated

Jim

Re: List Box conditioning

sunny_talwar — Tue, 13 Dec 2016 22:19:07 GMT

Please close the thread by marking the correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny