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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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