Using a Table: Set Analysis is effected another column

Anonymous — Wed, 18 Feb 2015 11:17:20 GMT

Hi All,

I created a report that shows ONLY customer purchases, if the customer didn't purchase anything in the last 3 months

(I call it Inactive customer report...)

I use a set analysis in a straight table like this:

Max( {$ <[Month Diff]={"<-$(Inactive Duration)"}>} Date)

** [Inactive Duration] is a variable that the user can change by himself

the expected result is as follows:

the problem is when i add an additional expression column, that says which product the customer purchased, like this:

CONCAT( distinct ServiceName,',')

**I use concat since the customer can purchase multiple items on the same date

this is the result i get:

meaning the last posting date shows as "-" since it doesnt apply the set analysis

my question is - why is it showing?

A few Details:

these are the tables that i am trying to set analysis: on the 3nd column on the Fact table, and the concat function is on the 2nd column

Re: Using a Table: Set Analysis is effected another column

sunny_talwar — Wed, 18 Feb 2015 11:28:30 GMT

Try this for Upgrade Description expression and see if this solves your problem:

If([Last Posting Date] > 0, yourCurrentExpression) (I can't read the name of your second last field from the second image, but that's what I think it is, use the exact name here)

This will force to remove all the Concatentated descriptions where there is no Last Posting Date in your chart.

HTH

Best,

topic Re: Using a Table: Set Analysis is effected another column in QlikView

Using a Table: Set Analysis is effected another column

Re: Using a Table: Set Analysis is effected another column