Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Previous Month data by Branch wise issue

HI

PFA

MayB1100
MayB2200
MayB3300
MayB4210
JunB190
JunB255
JunB366
JunB489

View solution in original post

15 Replies
Highlighted
MVP
MVP

Re: Previous Month data by Branch wise issue

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

Highlighted
Not applicable

Re: Previous Month data by Branch wise issue

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

Creator II
Creator II

Re: Previous Month data by Branch wise issue

Dear Manish,

         Thanks for quick reponse. I need Calculation in Frontend

Regards,

A.Harish

Highlighted
Creator II
Creator II

Re: Previous Month data by Branch wise issue

Hi  Roberto,

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

Regards,

A.harish

Highlighted
Master
Master

Re: Previous Month data by Branch wise issue

HI,

Check this,

Previous month.PNG

Hope this helps,

PFA,

Regards,

Hirish

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

Re: Previous Month data by Branch wise issue

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.

Highlighted

Re: Previous Month data by Branch wise issue

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

];

Highlighted
Creator II
Creator II

Re: Previous Month data by Branch wise issue

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.

Highlighted

Re: Previous Month data by Branch wise issue

like this?