Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
You can try,
Make it a straight table.
And change the null value to 0 for Listprice Dimension
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]; !
hi Kushboo ,
I need to handle it in script and i need a seperate column in qvd itself.
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?
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