Month Comparision

[sat_tok52]

Hi Guru's,

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

-Sateesh

[MayilVahanan]

Hi

Could you please share more details.

[#3]

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 ....

[jonathandienst]

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.

[sat_tok52]

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

[jagan]

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.

[sat_tok52]

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

[jagan]

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.

[jonathandienst]

>>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.