line graph for every Two months

[#1]

Hi all,

I need to display line graph as below.

From the start date in the table to today's date i need to display data for two months once.

I am using canonical date as dimension what need to change.

Measures:

Count({$<DateType = {invitation}>}invitation_id)

Count({$<DateType={accessed}>}invitation_id)

count({$<user_signed={1},DateType={signed}>}user_signed)

Regards,

Pramod

[MK_QSL]

you are missing single quote in set analysis

{'Value'}

Also you need to use SetAnalysis, AddMonths(Today(),-1)

Provide sample data, would try for you...!

[#3]

AddMonths(Today(),-1)  is not working.

[robert_mika]

Try like this

Try this expression

if(mod(YourDateDimension,2)=0,YourDateDiemnsion,Null())

Then untick the Show Null Values box

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[MK_QSL]

provide data in excel file along with your desired result...

[#6]

Hi Mika,

if(mod(CanonicalDate,2)=0,CanonicalDate,Null())

I am providing like above, it is displaying two days not two months, please help where i am doing wrong

[robert_mika]

Maybe

=if(mod(num(Year(CanonicalDate)))&num(Month(CanonicalDate))),2)=0,num(Year(CanonicalDate)))&num(Month(CanonicalDate))),2)

[#8]

Hi Robert Mika,

Once you check with the brackets '(' it's showing error in expression.

I am not getting where to add the brackets.

[robert_mika]

Sorry my bad:

=if(mod(num(Year(CanonicalDate))&num(Month(CanonicalDate)),2)=0,num(Year(CanonicalDate))&num(Month(CanonicalDate)),NULL())

[#10]

Hi Robert Mika,

Thanks it's getting but small issue, It,s not in the order and not in the date format "MM-DD-YYYY".

You can see the image. 2012 value is coming between 2014 and 2015

Please help to correct it