topic Re: Chart Calculations in QlikView

Chart Calculations

Thu, 13 Nov 2014 14:54:54 GMT

Hi All

I need some help...

I have a in my model fields ("Folder","File", "Reviewer" and "Reviewer Number" [ie. Reviewer 1, Reviewer 2, Reviewer 3, Reviewer 4]).

Each file gets reviewed and can be reviewed more than once by one or more people.

I now need to create some intelligence to see each file that was reviewed more than once by the same person and how many times.

How can I achieve this?

Re: Chart Calculations

simondachstr — Thu, 13 Nov 2014 15:03:00 GMT

You'll need an aggregated expression..

aggr(count(File),[Reviewer Number],File)

This expression will calculate the number of times each reviewer has reviewed each file. If you need a conditional show you can consider adding an if statement

e.g. Show all files that has been review by the same person more than once:

if(aggr(count(File),[Reviewer Number],File)>1, File)

I haven't tested the above, but theoretically it should work.

Re: Chart Calculations

Thu, 13 Nov 2014 15:33:34 GMT

Hi Martin

Thanks for your assistance.

I applied this instead and it seems to be working

(Aggr(Count([File),[REVIEW NUMBER],[File])>1,SUM([REVIEW NUMBER]))

only problem is I can still see records of files only reviewed once.

Do you know this is the case?

Re: Chart Calculations

simondachstr — Thu, 13 Nov 2014 15:52:58 GMT

Use the "suppress when value is zero" setting in the chart properties

Re: Chart Calculations

Thu, 13 Nov 2014 16:12:35 GMT

It''s already selected. The thing is, I only want to see records where file is reviewed more that once

Re: Chart Calculations

simondachstr — Thu, 13 Nov 2014 16:29:40 GMT

try suppressing nulls maybe.. the above conditional expression you've stated is already sorting out the ones which have not been reviewed more than once.