topic Re: Changing and limiting values in listbox (dynamically) in QlikView

Changing and limiting values in listbox (dynamically)

retko1985 — Mon, 09 Apr 2018 12:24:19 GMT

Hello,

I have this data in column / listbox:

What I want is to replace each D with word 'Department ', so it will be 'Department 1' instead of 'D1'. And I also want to remove the values N and TOTAL, so I will have only Department values in a listbox.

I need it dynamically, since i don't know how many departments I will have.

Can someone help me?

Thank you.

Re: Changing and limiting values in listbox (dynamically)

MK_QSL — Mon, 09 Apr 2018 12:29:23 GMT

Create List box using this expression

=Replace(IF(WildMatch(Department,'D*'),Department),'D','Department ')

Re: Changing and limiting values in listbox (dynamically)

saimahasan — Tue, 10 Apr 2018 10:01:24 GMT

Hope this solves your problem.