topic Re: Month Comparision in QlikView

Month Comparision

sat_tok52 — Fri, 04 Mar 2016 03:34:08 GMT

Hi Guru's,

How to get month format like Jan-feb ,Feb-Mar etc. I want this format.Any Help.

-Sateesh

Re: Month Comparision

MayilVahanan — Fri, 04 Mar 2016 04:37:46 GMT

Could you please share more details.

Re: Month Comparision

Fri, 04 Mar 2016 04:47:50 GMT

maybe something like .......

date(YOURDATEFIELD,'MMM') & '-' & date(monthstart(addmonths(YOURDATEFIELD,1)),'MMM')

If you want to reference it as a dimension then I'd suggest you stick it in a variable and then call the variable in your dimension. I just found it a little tiedier that way ...

Create a variable and call it ... vCUSTOMMONTH .... and then call it with $(vCUSTOMMONTH) as your dimension ....

Re: Month Comparision

jonathandienst — Fri, 04 Mar 2016 04:56:31 GMT

You will not get a lot of help with such a general question. Do you mean you want to simply months in the formayts you showed in your post? When does the month name change from Jan-Feb to Feb-Mar?

As always, post some example data and the output you want. That way you will get accurate and useful suggestions.

Re: Month Comparision

sat_tok52 — Fri, 04 Mar 2016 05:21:52 GMT

Sorry Jonathan,

Below is myrequirement.we have complete and Incomplete column both are flags 0 and 1 ,1-complete,0-Incompletd

how many treatments each Doctor had in a month

How many are completed and not completed.

Jan - Feb - 1) Complete

2) Incomplete

Feb - Mar - 1) Carry over of Incomplete Doctor from previous month Incomplete

2) New addition of Doctor - 1) Complete

2) Incomplete

Age Analysis of Complete in # of days

Sateesh

Re: Month Comparision

jagan — Fri, 04 Mar 2016 05:28:03 GMT

HI,

ATtach sample data and your expected result so that it would be easier to help you. People here help you when you come up with clear cut information.

Check this link to get answers quickly

Qlik Community Tip: Posting Successful Discussion Threads

Regards,

Jagan.

Re: Month Comparision

sat_tok52 — Fri, 04 Mar 2016 06:57:33 GMT

Hi Jagan,

Thanks for your response ,

Sorry i am unable to share my qvw. Could pls suggest me any approach how to achieve my issue.

Any help that would be really appreciate.

-Sateesh

Re: Month Comparision

jagan — Fri, 04 Mar 2016 07:01:49 GMT

Prepare some sample data in excel and share that otherwise it is very difficult. Just export some rows from your dashboard and change confidential information in community.

Check this link for various methods to share data in community.

Preparing examples for Upload - Reduction and Data Scrambling

Regards,

jagan.

Re: Month Comparision

jonathandienst — Fri, 04 Mar 2016 07:08:00 GMT

>>When does the month name change from Jan-Feb to Feb-Mar?

No response.

Supply some sample data. There is no need to upload sensitive information.