Expression to search the same table for a row with specific values
I have a table with the following sample data (first 3 columns) in Qlik Sense. What expression can give me the 4th column? Basically I am trying to search in the same table for a row with the same User ID as the current row, and a transaction type of 'Sale'.
Hello - thanks for your help. This doesn't appear to be working for me. Returns 0 for all rows.
If i try to break it down and make a measure with only this part: MaxString(total<[User ID]>[Transaction Type]) Then it always returns 'Lead' for every row
By the way, for my real data the expression looks like this: count(aggr(if(MaxString(total<user_id>type)='subscription' , [billing_changes.created_at] ),[billing_changes.created_at],user_id))
How can I figure out what i'm doing wrong? Have been messing with this one for a few days hehe
the strange thing is this part MaxString(total<[User ID]>[Transaction Type]), should return subscription as s is coming after l can you check if you have some leading spaces or something
Surely you values will matter for an expression to work. I would recommend a slightly different calculation that eliminates the if-statement and string-comparison, instead using set anlaysis.
