Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor

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.