topic Re: How do I create a trend chart ? in QlikView

How do I create a trend chart ?

Fri, 18 Apr 2014 14:22:38 GMT

Greetings

I am trying to analyze the trends. My client launched a new products where each user accumulate points every month when they participate in some activities.

When they launch the product in Mid July 2013,. they had 103 Members and gradually the membership increased every month.

Now I want to analyze the first 103 members point accumulating trends on monthly basis. how do I create a chart?

I have created the chart as follows but looks like I am wrong.

Chart 1,

Dimension :MONTH_CD

Expression :COUNT(USER_ID)

Chart 2:

Dimension :MONTH_CD

Expression :SUM(SCORE)

When I select Month 201307, then I am unable to see 201308,201309 etc for the users who participated in 201307. How do I analyze the trend for selective users?

Thank you

Re: How do I create a trend chart ?

alexandros17 — Fri, 18 Apr 2014 14:35:56 GMT

Try a cyclic group with Month and UserId

Re: How do I create a trend chart ?

swuehl — Fri, 18 Apr 2014 14:36:41 GMT

If you actually want to select the users active on the month which you are selecting, you would need something like a 'Select possible values' on the user field. You can either do this by using the context menu on the list box, or use set analysis with implicite field value definitions, i.e. the p() function.

Something along these lines:

=Sum({<USER_ID = p(), MONTH_CD= >}SCORE)

Re: How do I create a trend chart ?

Fri, 18 Apr 2014 14:46:33 GMT

you can use probable function in set analysis.

= sum({<USER_ID = p({<MONTH_CD={201307}>})>}SCORE)

Re: How do I create a trend chart ?

Fri, 18 Apr 2014 15:04:06 GMT

MONTH_CD is user selectable. If I use this statement in expression directly it is qv shows as error.

Re: How do I create a trend chart ?

Fri, 18 Apr 2014 15:05:57 GMT

Thanks Kumar

Now you have hard coded MONTH_CD=201307 how do i make this user selectable from list box?

Also some user who participate in 201307 may not participate in 201308 or other months. So is their any way I can show the count for the users?

Re: How do I create a trend chart ?

Fri, 18 Apr 2014 15:11:26 GMT

Thanks for the reply

Am I missing something?

In Dimension Edit Group-> New Group -> Added USER_ID and MONTH_CD

Then added the New Group to Dimension

When I click the cyclic icon entire users are populated. making it difficult to analyze.

Re: How do I create a trend chart ?

swuehl — Fri, 18 Apr 2014 15:20:32 GMT

MONTH_CD is user selectable. If I use this statement in expression directly it is qv shows as error.

Does it just show the red underlines, but saying 'Expression ok'? Could just be the known bug in the syntax checker.

If possible, post a small sample application.

Re: How do I create a trend chart ?

Fri, 18 Apr 2014 15:49:13 GMT

you can use a variable instead of hard coding it.

vMonth=getSelectedValue(MONTH_CD)

then selected value in list box reflected here.

for count of users, a set analysis equation is:

= Count({<USER_ID = p({<MONTH_CD={201307}>})>}USER_ID)

Re: How do I create a trend chart ?

Sat, 19 Apr 2014 01:43:36 GMT

Hi Nuthan Kumar

Thanks for the help.

I am using Qlikview version 11.20.12235.0

Looks like getSelectedValue function is not supported. Am I making any mistake?

Re: How do I create a trend chart ?

Sat, 19 Apr 2014 02:09:26 GMT

swuehl

Thank you for the reply. I think your suggestion is working.

I have added sample application and data files in my original thread.

Thank you once again.

Re: How do I create a trend chart ?

Sat, 19 Apr 2014 03:34:10 GMT

instead you can use:

getfieldselections ( FieldName [, ValueSep [, MaxValues]])

Returns a string with the current selections in a field.

ValueSep is the separator to be put between field values. The default is ', '.

Maxvalues is the maximum number of field values to be individually listed. When a larger number of values is selected the format 'x of y values' will be used instead. The default is 6.

Examples

getfieldselections ( Year )

getfieldselections ( Year, '; ' )

getfieldselections ( Year, '; ' , 10 )

Re: How do I create a trend chart ?

Sat, 19 Apr 2014 04:22:23 GMT

Hi Kumar

This does not work

My expression as follows

=sum({<USER_ID = p({<MONTH_CD={$(vMonth)}>})>}SCORE)

My Variable

vMonth==GetFieldSelections(MONTH_CD)

I have uploaded my original files in main thread. If you find time May I request you to look into the files?

Thanks anyway