2 Replies Latest reply: May 21, 2012 7:47 PM by John Reardon RSS

    How create custom product groups

      Hi.

       

      Our product names are set up the following way 1-1zz are Raw Materials, F-FZ are Finished Products and W-WZ are cartons etc.

       

      Is there a way for me to set these up as custom groups so I can add them to my filter in Qlikview so people can just switch between looking at FG, RM or carton data?

       

      The only way I can think of is to create an Excel spreadsheet with a list of every individual code and put them into groups that way, and then import the fields from the spreadsheet. This would be a hassle though, as everytime a new code is added (which is frequently), I'd have to update the spreadsheet.

       

      Is there a way to add the groups into the code?

       

      Thank you.