topic Re: Previous Month data by Branch wise issue in QlikView

Data

munna1317 — Sat, 26 Dec 2015 18:46:14 GMT

Hi Everyone,

I need Previous month COunt

Any Suggestions would be greatly appreciated.

Thanks in Advance.

Re: Previous Month data by Branch wise issue

MK_QSL — Sat, 26 Dec 2015 19:45:26 GMT

Do you need calculation at Script level or at front end?

Re: Previous Month data by Branch wise issue

Sat, 26 Dec 2015 21:54:50 GMT

Good evening, You can calculate both script and Set Analysis . You only need to match year month year month - January . Regards

Re: Previous Month data by Branch wise issue

munna1317 — Sun, 27 Dec 2015 09:22:53 GMT

Dear Manish,

Thanks for quick reponse. I need Calculation in Frontend

Regards,

A.Harish

Re: Previous Month data by Branch wise issue

munna1317 — Sun, 27 Dec 2015 09:26:04 GMT

Hi Roberto,

Thanks for response,I need this calculation in front end.Could you please tell me in detail.

Regards,

A.harish

Re: Previous Month data by Branch wise issue

HirisH_V7 — Sun, 27 Dec 2015 10:03:36 GMT

HI,

Check this,

Hope this helps,

PFA,

Regards,

Hirish

Re: Previous Month data by Branch wise issue

munna1317 — Sun, 27 Dec 2015 11:05:40 GMT

Hi Hirish,

the above function will give above value.if you look at my requirement.I need Previous month value by Branch wise i.e.., all the four branches should take Previous month.

Thanks in Advance .

Regards,

A.Harish.

Re: Previous Month data by Branch wise issue

Kushal_Chawda — Sun, 27 Dec 2015 11:46:32 GMT

See the attached

Data:

LOAD * INLINE [

Month, Branch, Amt

Apr, B1, 100

Apr, B2, 200

Apr, B3, 300

Apr, B4, 210

May, B1, 90

May, B2, 55

May, B3, 66

May, B4, 89

Jun, B1, 85

Jun, B2, 56

Jun, B3, 66

Jun, B4, 66

];

Re: Previous Month data by Branch wise issue

munna1317 — Sun, 27 Dec 2015 17:27:08 GMT

Hi Kush,

Thanks for response.I wanted in a Line Graph,if i use same Expression in line Chart,Values are incorrect.

Below are the values for your reference.

Month	Branch	Previous Month
Apr	810	-
May	300	-
Jun	273	-

Please suggest how to achieve in a Line Chart.

Regards,

A.Harish.

Re: Previous Month data by Branch wise issue

Kushal_Chawda — Sun, 27 Dec 2015 17:31:29 GMT

like this?

Re: Previous Month data by Branch wise issue

munna1317 — Sun, 27 Dec 2015 17:39:38 GMT

Correct Kush. Could you please send me the Application.

Regards,

A.Harish

Re: Previous Month data by Branch wise issue

Kushal_Chawda — Sun, 27 Dec 2015 17:45:56 GMT

see the attached

Re: Previous Month data by Branch wise issue

munna1317 — Sun, 27 Dec 2015 17:58:39 GMT

Hi Kush ,

I have seen the attachment,it is showing only month as dimension.I wanted in Line by Branch wise for Previous month.So X-Axis Should be month and Y Axis Should be Branch.

Line Graph with 2 Dimensions Month and Branch.

Regards,

A.Harish

Re: Previous Month data by Branch wise issue

munna1317 — Sun, 27 Dec 2015 18:04:40 GMT

Below Screenshot for your reference.Same way i need for Previous month.

Re: Previous Month data by Branch wise issue

MayilVahanan — Mon, 28 Dec 2015 04:15:00 GMT

PFA

May	B1	100
May	B2	200
May	B3	300
May	B4	210
Jun	B1	90
Jun	B2	55
Jun	B3	66
Jun	B4	89

Re: Previous Month data by Branch wise issue

Kushal_Chawda — Mon, 28 Dec 2015 06:54:11 GMT

See the attached

I have created the Cyclic group for expression so in same chart you can select the trend for Current as well as previous month values

May	B1	100
May	B2	200
May	B3	300
May	B4	210
Jun	B1	90
Jun	B2	55
Jun	B3	66
Jun	B4	89

May	B1	100
May	B2	200
May	B3	300
May	B4	210
Jun	B1	90
Jun	B2	55
Jun	B3	66
Jun	B4	89

May	B1	100
May	B2	200
May	B3	300
May	B4	210
Jun	B1	90
Jun	B2	55
Jun	B3	66
Jun	B4	89