Conditional Dimension in Qlikview

[Anonymous]

Hi

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.

[sunny_talwar · Accepted solution]

What you need is a calculated dimension

If(Match(Industry, 'Generics', 'Medical devices'), 'Pharmaceuticals/Biotech', Industry)

You can implement a similar logic in the script as well

[Anonymous]

Thanks a lot! this worked