Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
munna1317
Creator II
Creator II

Data

Hi Everyone,

         I need Previous month COunt

Any Suggestions would be greatly appreciated.

Thanks in Advance.

1 Solution

Accepted Solutions
MayilVahanan

HI

PFA

MayB1100
MayB2200
MayB3300
MayB4210
JunB190
JunB255
JunB366
JunB489
Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

15 Replies
MK_QSL
MVP
MVP

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

Not applicable

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

munna1317
Creator II
Creator II
Author

Dear Manish,

         Thanks for quick reponse. I need Calculation in Frontend

Regards,

A.Harish

munna1317
Creator II
Creator II
Author

Hi  Roberto,

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

Regards,

A.harish

HirisH_V7
Master
Master

HI,

Check this,

Previous month.PNG

Hope this helps,

PFA,

Regards,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
munna1317
Creator II
Creator II
Author

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.

Kushal_Chawda

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

];

munna1317
Creator II
Creator II
Author

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.

MonthBranchPrevious Month
Apr810-
May300-
Jun273-

Please suggest how to achieve in a Line Chart.

Regards,

A.Harish.

Kushal_Chawda

like this?