topic Re: comparison of current month vs previous year same month data in QlikView

comparison of current month vs previous year same month data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to create a straight table for comparison of current month vs previous year same month data as given below:

Month	Claims	Approved Claims
CYTD	10000	2000
PYTD	8000	1000

Any help with this is appreciated.

Thanks in Adavance

Anupama Jagan

P.S.

Attached sample data

The requirement is to get a table like below: For eg : current month is apr so the table should like this

Month	Claims	Approved Claims
Apr 2017	10000	2000
Apr 2016	8000	1000

Re: comparison of current month vs previous year same month data

MK_QSL — Wed, 05 Apr 2017 08:40:22 GMT

Provide sample data or app to work..

Re: comparison of current month vs previous year same month data

ahaahaaha — Wed, 05 Apr 2017 08:42:25 GMT

Hi,

may be as attached file.

Regards,

Andrey

Re: comparison of current month vs previous year same month data

Anonymous — Wed, 05 Apr 2017 08:42:40 GMT

Anupama,

Can you provide sample data?/ And do you want the table should be exactly like above??

Re: comparison of current month vs previous year same month data

Anonymous — Wed, 05 Apr 2017 08:52:39 GMT

Hi,

You can create two calendars in your data model.

if you can provide a sample date, it will be easier to help you

Re: comparison of current month vs previous year same month data

buzzy996 — Wed, 05 Apr 2017 09:10:38 GMT

try tis way,

=sum({$<Year={$(=Max(Year))},Month={"<=$(=max(Month))"}>}Sales)

=sum({$<Year={$(=Max(Year)-1)},Month={"<=$(=Month(Now()))"}>}Sales)

Re: comparison of current month vs previous year same month data

Anonymous — Wed, 05 Apr 2017 09:39:25 GMT

Hi Shiva,

Yes this is the requirement. I will attach a sample data soon

Re: comparison of current month vs previous year same month data

Anonymous — Wed, 05 Apr 2017 10:00:39 GMT

Hi All ,

I have now attached a sample data in the original post..

Thanks,

Anupama Jagan

Re: comparison of current month vs previous year same month data

Wed, 05 Apr 2017 10:59:35 GMT

Hi ,

Month,Month_id

Jan 1

Feb 2

Mar 3

....

Dec 12

Create a Month_id for the month field and use the following expressions in your straight table

=sum({<Crtd_Year={$(=Max(Crtd_Year)-1)}, Month_id={$(=max(Month_id))}>}Claims)

=sum({<Crtd_Year={$(=Max(Crtd_Year))},Month_id ={$(=max(Month_id))}>}Claims)

Regards,

Balakrishnan.R

Re: comparison of current month vs previous year same month data

Anonymous — Wed, 05 Apr 2017 11:30:31 GMT

!I have added one row data in the data source in order to test my result.

Hope the example below will help you.

Re: comparison of current month vs previous year same month data

Anonymous — Wed, 05 Apr 2017 11:43:57 GMT

Hi Sitrakiniaina,

In yours the table will display all the months for which value is there. I just want to display only for the current month and the last year same month data.

Thanks,

Anupama Jagan

Re: comparison of current month vs previous year same month data

Anonymous — Wed, 05 Apr 2017 11:45:48 GMT

Hi Balakrishnan,

This will help me to get all the data into straight table right. I just want to display only the current month and the last year same month data in the straight table.

Thanks,

Anupama Jagan

Re: comparison of current month vs previous year same month data

Wed, 05 Apr 2017 11:50:09 GMT

Hi,

The above expressions will calculate the value based on your selection , if you have not selected anything it will display the current month data only.

Regards,

Balakrishnan.R

Re: comparison of current month vs previous year same month data

Anonymous — Wed, 05 Apr 2017 11:54:01 GMT

You have two tables : the one "with set analysis" will display only the last year and the previous year .

The second table "without set analysis" was created just for test. To show you that normally we have 3 years for April.

Re: comparison of current month vs previous year same month data

Anonymous — Wed, 05 Apr 2017 12:38:08 GMT

Even in "with set analysis" once the selections are cleared out it is displaying all the values . My requirement is it should display only the current month and the previous year same month data only by default without any selections made.

Re: comparison of current month vs previous year same month data

Wed, 05 Apr 2017 12:54:30 GMT

Create a variable

vMonth=Month(Today) and then use it in the expressions as follows

=sum({<Crtd_Year={$(=Max(Crtd_Year)-1)}, Month_id={$(vMonth)}>}Claims)

=sum({<Crtd_Year={$(=Max(Crtd_Year))},Month_id ={$($(vMonth)}>}Claims)

Regards,

Balakrishnan.R

Re: comparison of current month vs previous year same month data

Anonymous — Wed, 05 Apr 2017 13:03:25 GMT

Okay I understand now

May be like this ?

Re: comparison of current month vs previous year same month data

Anonymous — Wed, 05 Apr 2017 13:10:46 GMT

Perfect! Thanks a lot

Regards,

Anupama Jagan

Re: comparison of current month vs previous year same month data

Anonymous — Wed, 05 Apr 2017 13:12:27 GMT

You're welcome

Re: comparison of current month vs previous year same month data

Anonymous — Wed, 12 Apr 2017 13:47:57 GMT

Hi All,

The above is requirement is slightly modified now. Could you please let me know if below is possible.

Month	Claims	Approved Claims
CYTD	10000	2000
PYTD	8000	1000

In this Month should display the current month. and the values under month should be CYTD and PYTD.

CYTD row Claims and Approved Claims should display the current yeah/month values and PYTD row should display previous year/ same month values.

Kindly let me know if this possible.

Thanks in Advance

Anupama Jagan