Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
yogitamehta10
Not applicable

selection

my filter is a conditional filter if (NO=('Ba'),Month_Year)

Month year formay  jan-2014.

my expression is

count({<NO={'Ba'},STATUS={'OPEN'},

Year={$(=max(Year))}

,[Calender MONTH]={$(=max([Calender MONTH]))},

[work_DATE] = {$(=Date(Max( {< NO={'Ba'}>} [workDATE])-1, 'DD/MM/YYYY'))SEQ_NO)

By defualt need to show latest month data , if i selcta nt thing from Month year (conditional filter) then is should show 'NA' for other months,.