topic Re: How to use Set Analysis in above case in QlikView

How to use Set Analysis in above case

Wed, 28 Dec 2011 09:08:34 GMT

Hi,

How to do this example ?

Thank you !

Re: How to use Set Analysis in above case

Wed, 28 Dec 2011 10:43:23 GMT

Add the date as a dimension in the chart and create a variable to get tomorrow's date ('vTormorrow' in the example expression) and use the following expression:

=SUM(PM) + SUM({<[date]={"=$(=Date($(vTomorrow)))"}>}AM)

Cheers,

Haneesh

Re: How to use Set Analysis in above case

Wed, 28 Dec 2011 11:08:31 GMT

Thank haneesh!

I use :

=count({$ < [Heure De Retrait] ={'>= 13'} >} [No Commande]) + count({<[Heure De Retrait] ={'<= 12'}, [Date Retrait]={$(= date([Date Retrait]+1, 'DD/MM/YYYY'))}>}[No Commande])

You see an error ?!

Re: How to use Set Analysis in above case

Wed, 28 Dec 2011 11:19:11 GMT

In your set analysis expression you are doing the date manipulation directly and this could cause issues at times. so, try creating a variable as follows,

vTomorrow = date([Date Retrait]+1)

and use this variable in the set analysis as follows,

=count({$ < [Heure De Retrait] ={'>= 13'} >} [No Commande]) + count({<[Heure De Retrait] ={'<= 12'}, [Date Retrait]={"=$(=Date($(vTomorrow)))"}>}[No Commande])

Re: How to use Set Analysis in above case

Wed, 28 Dec 2011 11:45:09 GMT

I used vTomorrow

but this part " count({<[Heure De Retrait] ={'<= 12'}, [Date Retrait]={"=$(=Date($(vTomorrow)))"}>}[No Commande]) "

is always =0

Re: How to use Set Analysis in above case

Wed, 28 Dec 2011 12:05:43 GMT

what is the expression used to define 'vTomorrow'?

Re: How to use Set Analysis in above case

Wed, 28 Dec 2011 12:05:52 GMT

Try changing

[Date Retrait]={"=$(=Date($(vTomorrow)))"}

[Date Retrait]={"$(=Date([Date Retrait] + 1))"}

I have run into wierd problems using a date variable in a set analysis expression before, because QV evaluated the date as a division - e.g. 28/12/11 was being interpreted as 28 divided by 12 divided by 11. This might be happening to you too.

Re: How to use Set Analysis in above case

Wed, 28 Dec 2011 12:27:54 GMT

vTomorrow = date([Date Retrait]+1)

Re: How to use Set Analysis in above case

Wed, 28 Dec 2011 13:21:15 GMT

Thank for the reply.

I tried to change

[Date Retrait]={"=$(=Date($(vTomorrow)))"}

[Date Retrait]={"$(=Date([Date Retrait] + 1))"}

but it's always = 0

Re: How to use Set Analysis in above case

Wed, 28 Dec 2011 13:22:59 GMT

I used :

count({<[Date Retrait]={"=$(=Date($(vTomorrow)))"}>}[No Commande]) : Not OK

count({<[Date Retrait]={$(=Date($(vTomorrow)))}>}[No Commande]) : Not OK

count({<[Date Retrait]={"$(=Date([Date Retrait] + 1))"}>}[No Commande]) : Not OK

count({<[Date Retrait]={$(=Date([Date Retrait]+1))}>}[No Commande]) : Not OK

count({<[Date Retrait]={"29/12/2011"}>}[No Commande]) : OK

Re: How to use Set Analysis in above case

Wed, 28 Dec 2011 14:37:45 GMT

Alternative ?

Re: How to use Set Analysis in above case

rbecher — Wed, 28 Dec 2011 14:52:03 GMT

I would transpose the data into daily rows. Then you can just summarize it with previous( ) function (order by date desc)..

- Ralf

Re: How to use Set Analysis in above case

Thu, 29 Dec 2011 08:48:53 GMT

Hi,

I updated the example.

Re: How to use Set Analysis in above case

rbecher — Thu, 29 Dec 2011 10:43:36 GMT

Expression for tomorrow is: below(count(NoCommande))

To ensure the right figures the sort of DateCommande should set to Ascending.

- Ralf

Re: How to use Set Analysis in above case

Thu, 29 Dec 2011 11:15:10 GMT

Thank Ralf !

How to use it for example2.qvw ?

Thank you once again !

Re: How to use Set Analysis in above case

rbecher — Thu, 29 Dec 2011 11:33:40 GMT

I don't see what is wrong with it..

Re: How to use Set Analysis in above case

Thu, 29 Dec 2011 17:01:42 GMT

I suggest you try the rangecount function. Since I'm not quite sure what the expected end result should be, I would encourage you to read the Help topic for the range functions used in conjunction with the above, below, before and after functions. The form of the expression will be something like:

rangecount (below(count({SET ANALYSIS stuff} yourfieldname),yourstartingrow,yourinterval))

Set Analysis can be applied to the count function and make sure to study the effect of the TOTAL keyword in these functions.

Re: How to use Set Analysis in above case

Fri, 30 Dec 2011 08:56:29 GMT

Thank you very much for your help !