Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Creator III
Creator III

How to write a previous month set analysis??

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

7 Replies
prahlad_infy
Creator
Creator

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

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

jim_chan
Creator III
Creator III
Author

i have added this

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

but stil not working.

prahlad_infy
Creator
Creator

send me sample data

arvind1494
Specialist
Specialist

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

Zhandos_Shotan
Partner
Partner

Add equation before expression:

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

sasiparupudi1
Master III
Master III

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

Hi!

Try this:

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

Skvortsov S.