Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
agastya
Creator
Creator

With and without year selection counts are mismatching

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

20 Replies
Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.