Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
Showing results for 
Search instead for 
Did you mean: 

please help on below requirement?


I have one requirement .

I have fields like       issues_id    issues_status

                                   1                  open

                                   2                  noaction

                                  3                  draft

                                   4                0pen             like that.just assume sample data.

i need create straight table and add two columns and i need toadd  two colomns using expressions. 

one field is previous distinct issues count and present distinct issues count.

1)when date is max(date)-1 means max date before  day,  issues_staus is draft count the distinct issusid

2)count disticnt issues_id ,when  issues_status is draft yesterday and it coverted to issues_status open ,noaction for today.