Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

line graph for every Two months

Hi all,

I need to display line graph as below.

monthwise.png

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

19 Replies
MK_QSL
MVP
MVP

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

Not applicable
Author

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


robert_mika
Master III
Master III

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

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

Not applicable
Author

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
Master III
Master III

Maybe

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

Not applicable
Author

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
Master III
Master III

Sorry my bad:

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

Not applicable
Author

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