Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (1)
19 Replies

Re: line graph for every Two months

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

Re: line graph for every Two months

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


Re: line graph for every Two months

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)

Re: line graph for every Two months

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

Not applicable

Re: line graph for every Two months

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

Re: line graph for every Two months

Maybe

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

Not applicable

Re: line graph for every Two months

Hi Robert Mika,

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

I am not getting where to add the brackets.

Re: line graph for every Two months

Sorry my bad:

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

Not applicable

Re: line graph for every Two months

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