Help

[nagarjuna_kotha]

Hi all,

i m trying on one thing i.e if select current month i want count for all Ticket Count at the same time i want count for previous Month also.Can any one help on this ?

PFA..

[sasiparupudi1]

=Count({<Month1={$(=Month(addmonths(makedate(Max(Year),max(Month1),1),-1)))}>}Month)

[vikasmahajan]

check this

Vikas

[nagarjuna_kotha]

Hi Sasidhar,

I m not asking Days Count.There my field Tic_No.Your Expression is working only for days Count.Please Correct it.

[sasiparupudi1]

Try

=sum({<Month1={$(=Month(addmonths(makedate(Max(Year),max(Month1),1),-1)))}>}Tic_No)

[jagan]

Hi,

Try like this

Current Month:

=Count({<Year=, Month1=, Month={'>=$(=MonthStart(Max(Month)))<=$(=Date(Max(Month)))'}>}Tic_No)

Previous Month:

=Count({<Year=, Month1=, Month={'>=$(=MonthStart(Max(Month), -1))<=$(=MonthEnd(Max(Month), -1))'}>}Tic_No)

Hope this helps you.

Regards,

jagan.

[qlikviewwizard]

Hi Nagarjuna,

Please select correct and helpful answers and close the thread. Thank you.

[jagan · Accepted solution]

Hi Nagarjuna,

Did you checked SasiParupudi1‌expression for 2016 January for Previous month expression?  It won't return correct numbers.

Instead check with below expression for same scenario

=Count({<Year=, Month1=, Month={'>=$(=MonthStart(Max(Month), -1))<=$(=MonthEnd(Max(Month), -1))'}>}Tic_No)

Hope this helps you.

Regards,

Jagan.

[nagarjuna_kotha]

Thankq Jagan 🙂