topic Re: Listbox problem in QlikView

Listbox problem

Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have two list boxes with a field KEYBILLING and LISTPRICE and CONDITIONTYPE.

If i select conditiontype there are no values against the listprice field , so all are greyed out (no selected values).

After that , if i create a table box somewhat like this ,,

Keybilling Listprice Conditiontype

1 - za00

2 - za00

now i want to replace that - with some values.

I have tried if(isnull(Listprice),0,1). But no result for me. Please help.

Re: Listbox problem

adamdavi3s — Thu, 22 Dec 2016 07:20:23 GMT

SO it sounds like the primary issue here is your data is not linked?

Is there a reason for this... its very hard to advise on this sort of issue without knowing more background on what you want to do.

However if you're content just working around it then try

if(len(Listprice)<1,0,1)

Or you can always change the 'null' and 'missing' display options in your chart (although not a table box)

Re: Listbox problem

Thu, 22 Dec 2016 07:33:04 GMT

You can try,

Make it a straight table.

And change the null value to 0 for Listprice Dimension

Re: Listbox problem

Thu, 22 Dec 2016 07:36:48 GMT

Hi Adam ,

Please find attached the screen shot and scrip i haave used.

LEFT KEEP(BILLING)

[List Price]:

LOAD

[KEY - Billing],

[EMEA Condition Type_/BIC/ZE_CONTYP./BIC/AZE_SDO2700] as [LP_CONDITIONTYPE],

ListPrice AS LISTPRICE

Resident BILLING;

INNER JOIN

LOAD

[Sales Org] as [LP_SALESORG],

[Condition Type] as [LP_CONDITIONTYPE]

FROM

[\\tow-t-qlikshare\Groups\QV_DATA_ETL\XFM_GTS\ME\EANZ_MasterData\SOM Maptest.xls]

(biff, embedded labels, table is Sheet1$)

WHERE Element='List Price';

FINAL:

LOAD

[KEY - Billing],

[LP_CONDITIONTYPE],

if(len(LISTPRICE)<1,0,LISTPRICE) AS LISTPRICE

RESIDENT [List Price];

DROP TABLE [List Price]; !

Re: Listbox problem

Thu, 22 Dec 2016 07:38:04 GMT

hi Kushboo ,

I need to handle it in script and i need a seperate column in qvd itself.

Re: Listbox problem

adamdavi3s — Thu, 22 Dec 2016 13:27:12 GMT

Hmmmm your code looks OK to me, I've literally written the same thing this morning and it is working fine.

I'm guessing you can't share a cut down qvw to look atl?

Re: Listbox problem

Fri, 23 Dec 2016 12:32:57 GMT

Hi adam thanks for your efforts. can you mail your gmailid so that i can send the qvw and qvd.

or please mail me karthijcet@gmail.com from your mail id