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
munna1317
Creator II
Creator II
Author

hi,

     It is not working .It results 0 value

PrashantSangle

Hi,

check in text box what is  your variable VarPrevFinMonth evaluating?

Sometime it convert your date to number

also check Your Fiscal Month format in list box

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 🙂
munna1317
Creator II
Creator II
Author

Hi Max,

   I have checked VarPrevFinMonth is evaluating in text box .Month Format is MMM(Jan)

and Fiscal month format also same  MMM(Jan)

PrashantSangle

Hi,

If possible post your sample apps?

One more thing if you want last month then add Year Field also in your set analysis.

Like,

Count({<[Fiscal Month]={"<=$(=VarPrevFinMonth)",[Fiscal Year]={"<=$(=VarYear)">}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 🙂
MayilVahanan

Hi

Instead of using month field, try with date field in set analysis for calculating from start date to end of previous month.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
munna1317
Creator II
Creator II
Author

hi ,

Can u please tell me how to get data till Previous Month end.

do you have any example Expressions or Conditions?

Regards,

Harish

munna1317
Creator II
Creator II
Author

Hi

I am using this Date field,but still i m getting 0 value

=Count({<CIDate={">=$(=DATE(MakeDate(2007,01,01),'DD-MM-YYYY')))<=$(=Date(Max(AddMonths(CIDate,-1)),'DD-MM-YYYY'))"} >}cmdbci_name)

MayilVahanan

Hi

Expression looks correct..

Did u please confirm that CIDate is also "DD-MM-YYYY" format or its in "MM-DD-YYYY" format?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
munna1317
Creator II
Creator II
Author

hi,

CIDate format is 'DD-MM-YYYY'

MayilVahanan

Hi

Can you provide a sample data in excel file ?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.