topic Re: Set Analysis in QlikView

Set Analysis

guya — Tue, 16 Oct 2012 11:47:57 GMT

Please, how can I do that?

I would like to create a chart showing the sum of the quantity of articles received, disregarding date selected for week days.

So it will be the sum of Mon, Tue, Wed, Thu, Fri not Sat & Sun.

Same for the total of last 6 months (Sep=x, Aug=y, Jul=z, etc...)

Thank You in advance

Guy

Message was edited by: GuyA Something like this...

Re: Set Analysis

swuehl — Tue, 16 Oct 2012 11:52:13 GMT

Not sure if I got your request, but maybe like

=sum({<WeekDay = {Mon, Tue, Wed, Thu, Fri}>} Quantity)

Assuming you created a WeekDay field in the script.

Re: Set Analysis

guya — Tue, 16 Oct 2012 12:01:46 GMT

It's showing the total for 5 days but I want the total by day.

Re: Set Analysis

swuehl — Tue, 16 Oct 2012 12:07:11 GMT

Ok, so you need to create a bar chart object with 1 dimension

WeekDay

and above expression.

Re: Set Analysis

guya — Tue, 16 Oct 2012 12:35:51 GMT

Think we are on the right way 🙂 but how to get data from this or only last week because it's retrieving data since the begining (don't need week data for all years in db).

Re: Set Analysis

Tue, 16 Oct 2012 12:44:26 GMT

You can restrict the data in your script by the following

Where Datefield >=

WeekStart(Today()-2)

Regards

Mhatim

Re: Set Analysis

guya — Tue, 16 Oct 2012 13:03:38 GMT

Can't restrict data (used of global datamodel) and don't know how to integrate "WeekStart(Today()-2)" to the previous set analysis.. sorry 🙂