Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
fariha_khan
Contributor II
Contributor II

Conditional Dimension in Qlikview

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.

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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

View solution in original post

fariha_khan
Contributor II
Contributor II

Thanks a lot! this worked