Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-03-03 03:24 AM

Issue in Expression-Count not correct

Hi,

PFA for the Sample QVW.

Test.jpg

This works when i select for one person.

For Person_addm2_key = 418 it is 384

and for Person_addm2_key = 429 its is 121.

Test.jpg

when i select both the PErson_addm2_key i should get the value : 384 + 121=505

But i am getting no values.

Test.jpg

can you please check the expression and help?

Issue.qvw
129 Views
0 Likes
1 Reply
MayilVahanan
MVP
MVP
‎2014-03-03 03:37 AM

HI

Try like this

=Sum(Aggr(Interval(MAX_SMOKE_QA_TIMESTAMP-JOIN_DT,'d'),PERSON_ADDM2_KEY))

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & likes if you like the post.
63 Views