topic Re: Variable storing multiple material number seperated by comma in QlikView

Variable storing multiple material number seperated by comma

Sun, 21 Jul 2013 12:34:59 GMT

Dear friends

I want to use a variable in set analysis which contains the list of material number seperated by comma for a selected supplier.

Can we store multiple material number for a selected supplier in a variable , the number should be seperated by comma.

Pls do share comments or suggestions

Many thanks

Rahul

Re: Variable storing multiple material number seperated by comma

Gysbert_Wassenaar — Sun, 21 Jul 2013 16:37:28 GMT

If you select only one supplier something like concat(distinct material_number, ',') would create a concatenated list of comma separated material numbers for that supplier. Replace material_number with the name of the field that contains the material numbers.

Re: Variable storing multiple material number seperated by comma

Mon, 22 Jul 2013 05:07:29 GMT

Hi Gysbert

Many Thanks!

It works perfectly.

Rahul Kale