Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Giselle100
Contributor III
Contributor III

Creating dimensions from a list

Test Type ID: 1,2,3,4

Test Type Description: Fit, Fabric, Red, Green

Approve Date

 

I need to create separate dimensions for the Test Type Description as I would like to use them individually.

1. Fit Test = If([Test Type ID]=1, [Approve Date])

2. Fabric Test = If([Test Type ID]=2, [Approve Date])

3. Red Test = If([Test Type ID]=3, [Approve Date])

4. Green Test = If([Test Type ID]=4, [Approve Date])

 

These dimensions work fine on their own as i can untick not to display the nulls byt when I use them all together, I have to uncheck the "don't display the nulls" as the rest of the fields won't display and also it creates extra lines.

 

How else can I write these expressions so that I can use them together in a table without it creating extra null lines?

Labels (3)
1 Reply
Lauri
Specialist
Specialist

Why do you calculate these four dimensions, instead of using the existing "Approve Date" field?