Solved: when adding dimensions key attribute gets "lost"? - Page 2 - Qlik Community

Anonymous · ‎2015-03-06

hi all

so this is a little convoluted but bear with me.

i have 2 tables.

1 table contains

style

color

active (0/1 flag)

2nd table contacts

style

color

customer

sales

so i do a pivot table.. where the natural link between the 2 tables are style/color

heres where it gets wonky.

i guess since active is on style/color and not style/color/customer..

when i do a pivot.. and add customer as a dimension..

then do an expression to add total sales

it loses active = yes/no for a style color if the customer never purchased the style.

so my issue is.. the style/color is active.. but i need to know its active even if no one bought the style (within the expressions)

so sales is zero.. but since customer never bought it.. it doesnt know about it.. or loses it within the dimension of 2(customer)...

how do i tell it to check dimension 1 for active/inactive?

thanks

Anonymous · ‎2015-03-09

im a dummy.. missed it

sorry will look into it.

thanks

Anonymous · ‎2015-03-09

ah..

so theres no way to do.. where i can split the style to be a dimension up top?

the format the users are looking for is.. styles up top.. colors/customers on the side..

like the setup i have where i get this issue.

thanks

rwunderlich · ‎2015-03-09

I think your solution is to use this for the background color expression:

if(sum(TOTAL<style, color>active)>0,blue(),red())

See attached.

-Rob

Anonymous · ‎2015-03-09

perfect...

i was going down this route.. but i couldnt figure out where the active # went.. by the time i got to the expression..

total --- so simple.. yet so hard..

thank you sir..