topic how can we make this chart in QlikView

how can we make this chart

Thu, 12 Aug 2010 08:02:24 GMT

how can we make this chart if i select Aug-2010

then we want to see figure last year previous three month just like ( june-2009,july-2009,Aug-2009).

How can we make this logic help me urgent basic .

Regards

Ashish Srivastava

how can we make this chart

Thu, 12 Aug 2010 09:00:37 GMT

Dear All

kindly requested to you please help me in this issue.

It's a very urgent,

Regards

Ashish Srivastava

how can we make this chart

Thu, 12 Aug 2010 09:09:36 GMT

no comprenday

how can we make this chart

Thu, 12 Aug 2010 09:16:41 GMT

Yes compredday

Example if i select 11-Aug-2010

Then we want to see data for 1-june2009 to 11-Aug-2009 month wise.

Regards

Ashish Srivastava

how can we make this chart

Thu, 12 Aug 2010 10:12:34 GMT

Help me.

Regards

Ashish Srivastava

how can we make this chart

Thu, 12 Aug 2010 10:25:06 GMT

i dunno

how can we make this chart

Thu, 12 Aug 2010 10:28:52 GMT

Dear Ashish,

PFA of Rolling.qvw may be it is helpfull for you

how can we make this chart

Thu, 12 Aug 2010 12:19:31 GMT

Dear Santhosh,

Thank for helping me but we want previous three month data.

What ever you select month.

Regards

Ashish Srivastava

how can we make this chart

Thu, 12 Aug 2010 13:03:30 GMT

Hi,

If you are using QV 8.5 or later version, your code should be smilar to following code.

//untested code

sum({<Selection_Field = {">=$(=Monthstart(addmonths(Selection_Field,-3)))}<=Max(Selection_Field)"})

-Sridhar

how can we make this chart

Thu, 12 Aug 2010 13:18:25 GMT

Hi Sridhar,

I have test this code but it's not working.

Kindly requested to you if you have any qvw example file please send me this is more use full for me.

Currently i have used qlikview 8.5 version.

Regards

Ashish Srivastava

how can we make this chart

Thu, 12 Aug 2010 13:55:53 GMT

Hi,

I dnt have any example doc now. i`ll try to do and post.

for now check the below code. if this not working pl post a sample of data in excel and o/p

sum({<Selection_Field = {">=$(=Monthstart(addmonths(Selection_Field,-3)))}<=$(=Max(Selection_Field))"})

- Sridhar

how can we make this chart

Thu, 12 Aug 2010 14:02:13 GMT

Here is an example for previous period calculation.

how can we make this chart

Thu, 12 Aug 2010 14:37:22 GMT

Hi,

Here another example.

how can we make this chart

Wed, 08 Sep 2010 13:48:41 GMT

Hi Ashish,
I am facing one problem in set analysis in using (NOT IN)
Clause .
I am having cases where i am having file Nos (DebtNo.) those
are present in Current month(Suppose-Aug)
and Having File No those are present in Previous month that
will be July .
Now i want one result using set anlysis in which i can get
cases those were present in July BUT NOT IN August ..
....

or i can take another case like i want cases from
august(Current Month) those were absent (Not in) in July .

How can i get this result using set anlysis because i am
using current and previous month logic here .
Please find out attached doccuement for your refrence and
suggest if you can do the needfull changes in that
doccument.

As per my uderstanding we should use (NOT IN) Syntax but i
dont know how to use or implement this is set analysis...
Please help me .......... its urgent

Please reply me @

dushyant@iconresources.com]