topic Re: List box data in QlikView

List

Anonymous — Thu, 25 Aug 2016 09:09:51 GMT

Hi ,

Please find the attached document and please provide me the suggestions.

Re: List box data

adamdavi3s — Thu, 25 Aug 2016 09:21:29 GMT

Here is a little something you can add in the script to do this if you want to load the data in:

preceedingload:
load EId,Ename,if(EId='ABCE005' AND Ename = '-', 'Logistics',Dept) as Dept;

LOAD * INLINE [
    EId, Ename, Dept
    E001, James,IT
    E002, Tom,Sales
    E003, Jim,ENGG
    E004, Henry,MARKT
    ABCE005, -
    ABCE006, -
];

If you end up with loads of blanks to fill in then you could use a mapping table or a pick match to make it much more efficient

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

Re: List box data

Anonymous — Thu, 25 Aug 2016 09:31:01 GMT

Thanks Adam for response

Could you please explain me how to do at front end

Re: List box data

Anonymous — Thu, 25 Aug 2016 09:36:55 GMT

Any suggestions pls

Re: List box data

adamdavi3s — Thu, 25 Aug 2016 09:37:35 GMT

You should be able to do exactly the same, just put the if formula in the list box as an expression.

I've attached a file which includes this for you

Re: List box data

adamdavi3s — Thu, 25 Aug 2016 09:47:57 GMT

any help?

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

Re: List box data

MindaugasBacius — Thu, 25 Aug 2016 09:58:01 GMT

Try like this:

LOAD EId
  ,Ename
  ,if(EId = 'ABCE005' and Ename = '-', 'Logistics', Dept) as Dept
INLINE [
    EId, Ename, Dept
    E001, James,IT
    E002, Tom,Sales
    E003, Jim,ENGG
    E004, Henry,MARKT
    ABCE005, -
    ABCE006, -
];

Result:

See the attachment.