Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

Filter distinct Count() for only a condition

Hi i need to filter my Count() only when a condition is verified, in details:

count.png

i need to Count, only items where my field ANNO_EMI = ANNO + 1

28 Replies
sunny_talwar

I don't see any qvw sample

danosoft
Specialist
Specialist
Author

I already sent in first post, but i resend no problem:

graphann.png

this is the sample, you see i not visualize nothing in the chart... i need to display the line that rapresent my COUNT of my PDR that i have in the database for condizion MESE_EMISSIONE = MESE_COMPETENZA + 1

sunny_talwar

This is an image... I am sure someone else might be able to help better

Best,

Sunny

danosoft
Specialist
Specialist
Author

ok i understand the project where i have this layout is really big, i will try to reduce it and make an example and i will post here, thanks

danosoft
Specialist
Specialist
Author

Hi i upload the project hope it can be open

thanks

danosoft
Specialist
Specialist
Author

Hi i upload the example, can you help me with that ?

asilveira
Contributor
Contributor

try the first option, maybe the problem is that field "ANNO_EMI" not exist.

so, the correct expression is:

=Count (Distinct {<ANNO_EMISSIONE ={'$(ANNO) + 1'}>} PDR)

I hope it has been helpful.

Regards,

Alvaro Silveira

danosoft
Specialist
Specialist
Author

no is not that

danosoft
Specialist
Specialist
Author

possible nobody can't help me? Sunny said me to upload an example and i did it,

is so difficult make a line chart where i can take a COUNT of my item PDR where my MESE_EMISSIONE = MESE_COMPETENZA + 1 ?