Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share a sample to look at this?
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
I need to create a sample of this.. if u want the same. Take some time. haha. SSure post it up
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
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 1st Expression and tick Hide Column…