topic Re: Setanalysis in QlikView

Setanalysis

NavinReddy — Fri, 14 Feb 2014 04:43:43 GMT

Dear All,

I am using set analysis to display current month salary

=sum({<Date={">=$(=MonthStart)<=$(=MonthEnd)"}>}Salary)

But using this set analysis im getting last month Salary Also

could some one help me to display current month salary only

Thanks In Advance

Niranjan

Re: Setanalysis

Fri, 14 Feb 2014 05:07:25 GMT

Hi Niru,

For Ex,

=sum({<Month ='Jan'>}Salary)

Re: Setanalysis

Fri, 14 Feb 2014 05:11:43 GMT

Hi,

Hope try this,

Sum({$<Month={$(=Max(Month))}>}[salary])

Re: Setanalysis

NavinReddy — Fri, 14 Feb 2014 05:38:57 GMT

Hi Kumar,

I need to display current month starting date to Till date Salary

Regards,

Niranjan

Re: Setanalysis

Fri, 14 Feb 2014 05:42:22 GMT

Are you trying to show the all the dates between start date and end of the month?

Re: Setanalysis

NavinReddy — Fri, 14 Feb 2014 05:45:34 GMT

yes Sneha ......

Re: Setanalysis

Fri, 14 Feb 2014 05:53:23 GMT

You can create two variables for current month start date and end date.

And the use can use expression like

=sum({<Date={">=$(=vStart)<=$(=vEnd)"}>}Salary)

Re: Setanalysis

preminqlik — Fri, 14 Feb 2014 05:58:03 GMT

hi try this

sum({<Year={$(=max(Year))},Monthnum={$(=max({<Year={$(=max(Year))}>}Monthnum))},Date={'<=$(=max(Date))'}>}Salary)

here for Monthnum, do in backend like below :

num(Month(Date)) as Monthnum

Re: Setanalysis

NavinReddy — Fri, 14 Feb 2014 06:01:41 GMT

Yes i Followed the same way

you can check my expression above i m following the same technique

=sum({<Date={">=$(=MonthStart)<=$(=MonthEnd)"}>}Salary)

but im getting last month salary values also

plz help me

Regards,

Niranjan

Re: Setanalysis

jagan — Fri, 14 Feb 2014 06:48:06 GMT

Hi,

Check whether dates in the variables and Date dimension are in same format and also check the values in the variables.

If date format differs then it wont work as expected.

=sum({<Date={">=$(=MonthStart)<=$(=MonthEnd)"}>}Salary)

Regards,

Jagan.

Re: Setanalysis

NavinReddy — Fri, 14 Feb 2014 06:52:19 GMT

Hi jagan

LOAD * INLINE [

Date, Salary

01/01/2014, 100

03/01/2014, 200

06/01/2014, 300

07/01/2014, 400

10/02/2014, 500

11/02/2014, 600

12/02/2014, 700

13/01/2014, 800

];

=sum({<Date={">=$('01/02/2014')<=$('28/02/2014')"}>}Salary)

i Tried this expression This is also not working

Regards,

Niranjan

Re: Setanalysis

jagan — Fri, 14 Feb 2014 06:58:57 GMT

Hi,

Try like this

Data:

LOAD

Date(Date#(Date, 'DD/MM/YYYY')) AS Date,

Salary

INLINE [

Date, Salary

01/01/2014, 100

03/01/2014, 200

06/01/2014, 300

07/01/2014, 400

10/02/2014, 500

11/02/2014, 600

12/02/2014, 700

13/01/2014, 800

];

=sum({<Date={">=$(=Date(Date#('01/02/2014', 'DD/MM/YYYY')))<=$(=Date(Date#('28/02/2014', 'DD/MM/YYYY')))"}>}Salary)

Regards,

Jagan.

Re: Setanalysis

NavinReddy — Fri, 14 Feb 2014 07:11:15 GMT

Thank you jagan its working