Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
gkcchowdary
Creator
Creator

help on below scenario?.

Hi

I have two fields RiskID and DATE.

I have created previous date and current date by using us. if I select one date from previous and one date from current it will give few RiskIDs .

Now I want to get the count of RiskIDs  which are not present in previous date but it present in current date.

how to implement the above requirement.

Thanks.

3 Replies
YoussefBelloum
Champion
Champion

Hi,

how did you create the previous date and current date ? on the script ? two different separated fields ?

if that's what you have, you can try this:

Count({<Previous_date-={'$(=Getfieldselections(Previous_date))'}>}RiskIDs)

YoussefBelloum
Champion
Champion

After making some test, I would recommend this (I don't know why)

Count({<Previous_date =- {'$(=Getfieldselections(Previous_date))'}>}RiskIDs)


the only difference is the position of the minus sign - near the equal sign, before or after

gkcchowdary
Creator
Creator
Author

thanks for your reply Youssef. I will check your expression it works or not.