topic Re: How to write a previous month set analysis?? in QlikView

How to write a previous month set analysis??

jim_chan — Thu, 08 Nov 2018 02:31:11 GMT

Hi guys,

i want to look for a previous month count. here my set analysis.

Count({$< Channel= {'TV1'}, Month(addmonths(max(master_date) ,- 1))}>}ID)

I think my set analysis is wrong.. i couldnt get any result. please help@!

Rgds

Jim

prahlad_infy — Thu, 08 Nov 2018 03:28:47 GMT

vMonth= (Month(Addsmonth(Today(),-1))

<Channel= {'TV1'}, Month_Field={'$(vMonth)'}>

jim_chan — Thu, 08 Nov 2018 03:48:35 GMT

i have added this

count(<Channel= {'TV1'}, month={'$(vMonth)'}>ID)

but stil not working.

prahlad_infy — Thu, 08 Nov 2018 04:08:57 GMT

send me sample data

arvind1494 — Thu, 08 Nov 2018 06:09:56 GMT

Count({< Channel= {'TV1'},Month_Field= {$(=max(Month_Field)-1)}>}ID)

Zhandos_Shotan — Thu, 08 Nov 2018 07:52:24 GMT

Add equation before expression:

vMonth= '=Month(AddMonths(Max(master_date),-1)'

sasiparupudi1 — Thu, 08 Nov 2018 08:34:54 GMT

You have to have a month period field .. Could you pl share a sample?

ex: if you have a filed that is in NOV 2018 format,

=count({<Channel= {'TV1'},MonthYear={"$(=Date(AddMonths(Today(),-1),'MMM YYYY'))"}>} ID)

sergioskv — Thu, 08 Nov 2018 11:42:05 GMT

Hi!

Try this:

Count({$<Channel= {'TV1'},Master_date={">=$(=Addmonths(min(Master_date),-1))<=$(=Addmonths(max(Master_date),-1))"}>}ID)

Skvortsov S.