Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
daisy1438
Contributor III
Contributor III

help me on below requirment?

Hi All,

I have table with fields ID and date and region.

Some Id s not available in previous date and some id are available in current date.

using above date field divided into previous date and current date .

1)when user select previous date and current date count the Id what are the id not available in previous date and available in current date

2)same way user select previous date and current date what are the Id s available  in previous date and not available in current date than count the ids.

Ex:we have 4 months dates jan to apr.

if user select  previous date 10-feb-18  and  current date 23-apr-18 than count the id s.

compare only 10 feb and 23 apr .not in between dates.if user not select any dates showing the entire Id s.

how to implement this.

3 Replies
juraj_misina
Luminary Alumni
Luminary Alumni

See attached app, it might help.

Juraj

daisy1438
Contributor III
Contributor III
Author

Thanks Juraj.

App not attached could you please attaché once again.

juraj_misina
Luminary Alumni
Luminary Alumni

Strange, I can see it there

Capture.PNG