topic Help in QlikView

Help

nagarjuna_kotha — Mon, 31 Aug 2015 06:16:23 GMT

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

Re: Help

sasiparupudi1 — Mon, 31 Aug 2015 06:49:42 GMT

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

Re: Help

vikasmahajan — Mon, 31 Aug 2015 06:53:40 GMT

check this

Vikas

Re: Help

nagarjuna_kotha — Mon, 31 Aug 2015 06:59:24 GMT

Hi Sasidhar,

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

Re: Help

sasiparupudi1 — Mon, 31 Aug 2015 07:05:03 GMT

Try

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

Re: Help

jagan — Mon, 31 Aug 2015 07:32:38 GMT

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.

Re: Help

qlikviewwizard — Mon, 31 Aug 2015 07:58:11 GMT

Hi Nagarjuna,

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

Re: Help

jagan — Mon, 31 Aug 2015 08:50:22 GMT

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.

Re: Help

nagarjuna_kotha — Mon, 31 Aug 2015 10:02:58 GMT

Thankq Jagan 🙂