Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

When 2020 is not selected still it will show 349 count only 

 

something like this(sample)

Vis_0-1597148854733.png

 

Highlighted

Would it be possible for you to share a sample?

Highlighted
Creator
Creator

=Count({aggr(
if((MaxString({<NewFlag_Ignore={'N'}>}DRAWING_REVISION_Number)-MinString({<NewFlag_Ignore={'N'},Created_Year=>}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)) 

 

Using Above expression

Above expression giving correct o/p with selection without other possible years data not including in the Selected year (2020)

 

Highlighted

okay, but you still need help with without selection, correct? Can you share a sample so that we can help you with that?

Highlighted
Creator
Creator

Sunny i can't share any sample customer confidential 

Can you please help me out to modified the expression /how can i include possible value which is reflecting in other years.

 

Highlighted

I am not asking to share confidential data. All I need is a sample where I can see the issue... and this can be done in mocked up sample where the data is all made up data.

I am not sure I understand what you have which is why I am having issues in giving you an expression which works.

Highlighted
Creator
Creator

Final expression :-=

=Count({1}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))

Highlighted

This worked?

Highlighted
Creator
Creator

Working for with selection not for without selection:(

Highlighted

okay, I am not sure how to help with just looking at the expression. May be someone else can