Analyzing trend using Set Analysis

Mon, 21 Apr 2014 00:39:42 GMT

Greetings

I am trying to analyze the trend.i.e A group of users score I want to analyze over a period of time.

I have requested for help in my previous posting

The solution provided is working but I would like to clarify whether I should put condition in Set analysis also Need to set distinct.

Suppose if I choose 201307 where we have 95 users who had a score. Actual users are 103 because remaining 8 users never had any score , This users may or may not be participated in 201309 or 201308 etc. SInce I am analyzing only this 95 users I thought I will set COndition Score >0. Not sure we need DIstinct to be set.

If I need to set Condition Score >0 or DISTINCT where should I set in the second chart set analysis?

Thank you in advance.

Re: Analyzing trend using Set Analysis

jagan — Mon, 21 Apr 2014 04:00:21 GMT

Hi Ram,

You can use this expression instead of If, also if you have only one score for one month then there is no need for distinct, otherwise you need to use Distinct in expression.

=Count({<SCORE={'>0'}>}DISTINCT USER_ID)

Hope this helps you.

Regards,

Jagan.

topic Re: Analyzing trend using Set Analysis in QlikView

Analyzing trend using Set Analysis

Re: Analyzing trend using Set Analysis