Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
munna1317
Creator II
Creator II

Set analysis problem

hi QV,s

Can you plz Tell me this Expression in Set analysis

I have CMDBCI table.

Req:I want count of CmDBCInames for current month/Count(CmdbCi Names till Previous month)

Thxs in advance

harish

22 Replies
MK_QSL
MVP
MVP

What is the format of your date field?

munna1317
Creator II
Creator II
Author

hi manish,

format of your date field:DD-MM-YYYY

MK_QSL
MVP
MVP

Have you created a Master Calendar?

Also,

What is the meaning of till Previous Month? You want starting from your first date from database to previous month end?

Count(CmdbCi Names till Previous month)

Please clarify little more on above two questions, which will make easy to answer.

munna1317
Creator II
Creator II
Author

you are Correct,I want starting from my  first date of  database to previous month end.

I have created Master calendar



MK_QSL
MVP
MVP

Can you provide sample data base or apps?

MK_QSL
MVP
MVP

For Previous Month End

=SUM({<TransactionDate = {'<=$(=MonthEnd(AddMonths(Today(),-1)))'}>}Amount)

For Current Month

=SUM({<Month = {'$(=Month(Today()))'},Year = {'$(=Year(Today()))'}>}Amount)

You can change the field names according to your application...

christian77
Partner - Specialist
Partner - Specialist

Hi Manish

It is simpler

MonthStart(Today())-1

than

MonthEnd(AddMonths(Today(),-1))

results are the same

salutes

munna1317
Creator II
Creator II
Author

Hi Manish,

The Expression for Prevous Month is giving only Previous month Count.I need total count ( from starting date of my database )

Expression for Previous Month:

=Count({<[Fiscal Month]={'<=$(VarPrevFinMonth)'>}cmdbci_name)  it is not Working.


Regards,

Harish


PrashantSangle

Hi,

Expression for previous Month End:

=Count({<[Fiscal Month]={"<=$(=VarPrevFinMonth)">}cmdbci_name)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂