With and without year selection counts are mismatching

[agastya]

Hello Team,

Hope you all doing great!!!!!

Dimension :-  If(Year="2020",Year)

Expression :-

Count(aggr( if((MaxString({<NewFlag_Ignore={'N'}>}DRAWING_REVISION_Number)-MinString({1<NewFlag_Ignore={'N'}>}DRAWING_REVISION_Number))>0,
if((MaxString({<NewFlag_Ignore={'N'}>}DRAWING_REVISION_Number))>(MinString({<NewFlag_Ignore={'N'}>}DRAWING_REVISION_Number)),
(MaxString({<NewFlag_Ignore={'N'}>}DRAWING_REVISION_Number)-MinString({<NewFlag_Ignore={'N'}>}DRAWING_REVISION_Number)),'')),Drawing_Roo_Program_Key))

If i am making year selection i.e 2020 in this case i am getting current count as "349"  

when i am deselecting the Year selection count are mismatching i.e  "103"

Thank you looking for positive reply:)

@sunny_talwar @bharathadde

[Brett_Bleess]

To make a point here regarding QVW files, you can always use the Settings\Document Properties\Scrambling tab in any QVW file opened in the Desktop Client to scramble any fields that have sensitive data in them in order to be able to attach them to posts...  In this case, I would agree with Sunny, it would be most helpful for you to attach the QVW or a sample QVW with your similar data model etc., otherwise you will likely have to sort things on your own.  The only place I could point you in that case would be the Design Blog area to search for posts there that may be pertinent:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett