I am really new to qlik view and I hope someone can help me on this. I have the following data and I want to create a bar chart out of it. However, instead of showing all the fields I would like to merge Generics and Medical devices under Pharmaceuticals/Biotech and create a new dimension point pharmaceuticals/biotecs and generics to show in my chart. Is it possible to do it with Qlik View?
I would really appreciate if someone can help me on this.