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: 
Not applicable

Problem with dimension and if condition

Hello,

I have a problem and I am not so sure it has a answer, but if you know something please help!

table 1CoolersDepartment% Share
88,5%
Refrigeratorinvaded88,5%
Refrigerator70% stock88,5%
table2: what I have nowCoolersinvaded70% stock% Share
Refrigerator"red cross""red cross"88,5%
invadedif(Department='invaded','qmem://<bundled>/BuiltIn/check_g.png','qmem://<bundled>/BuiltIn/cross_r.png')
70% stockif(Department='70% stock','qmem://<bundled>/BuiltIn/check_g.png','qmem://<bundled>/BuiltIn/cross_r.png')
table 2: waht I wantWhat I want to see is :
Coolersinvaded70% stock% Share
Refrigerator"green check""green check"88,5%
If I had  on table 2 the department included in the dimensions it would be like this
Coolersdepartmentinvaded70% stock% Share
Refrigeratorinvaded"green check""red cross"88,5%
Refrigerator70% stock"red cross""green check"88,5%
This is correct, but I want to see it in just one line both with green check
Going back to table 2 :
Coolersinvaded70% stock% Share
Refrigerator"red cross""red cross"88,5%
If I introduce on the side a Department filter and select one of the two it will appear its green check
filter department: invaded selected
Coolersinvaded70% stock% Share
Refrigerator"green check""red cross"88,5%
Again what I expect is to see both on green since both are included in the coolers refrigerator type.
0 Replies