Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Sunny
Now only the header of the list box shows.
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)
Sorry i'm not sure what your asking. This is were i put the code and the result is on the right
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)
That was it.
Thanks for your help it was greatly appreciated
Jim
Please close the thread by marking the correct response.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny