Set Analysis to display new record in a text box object

[jim_chan]

HI guys,

I am following this post regarding how to use set analysis for new record. I was following 1 of the sample:

How to check if Record exist in Previous Month ? | Qlik Community

in the straight table expression, it is written as:

IF(COUNT({<batch_year = {'<$(=Max(batch_year))'}, risk_item_id = P({<risk_item_id>})>}risk_item_id)>0,'NO','YES')

I wonder how can i change or convert this line of code to show me amount of new records in text box object.

Rgds,

Jim

[sunny_talwar]

Would you be able to share a sample to look at this?

[jim_chan]

Bro, actually I follow this post. And I created the a sample based on the online data sample given in that post too.

I also couldn't create a count of the records based on the sample given there

[jim_chan]

I need to create a sample of this.. if u want the same. Take some time. haha. SSure post it up

[sunny_talwar]

So you want me to work on a sample? I might not be able to come up with a sample on my end, but if you have it, I am more than happy to look at it

[jim_chan]

Yes bro, this is what posted on the community:, can you try to get the Count with your expression?

Use below table in script..

============================

Load
Product,
Date#(ReportMonth,'MMM-YYYY') as ReportMonth
Inline
[
Product,       ReportMonth
ABC,        Jan-2014
EFG,        Jan-2014
ABC,        Feb-2014
EFG,        Feb-2014
ABC,        Mar-2014
EFG,        Mar-2014
EFG,        Apr-2014
HIJ,        Apr-2014

];

=============================

Now create a chart with below dimensions and expressions

Dimension

Calculated Dimension

=IF(NOT IsNull(ReportMonth),Product)

Expression

COUNT(DISTINCT Product)

IF(COUNT({<ReportMonth = {'<$(=Max(ReportMonth))'}, Product =P({<Product>})>}Product)>0,'NO','YES')

Go to presentation tab

Select 1^st Expression and tick Hide Column…