Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

MVP
MVP

Re: Filter distinct Count() for only a condition

I don't see any qvw sample

Highlighted
d_caprelli
Contributor II

Re: Filter distinct Count() for only a condition

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

MVP
MVP

Re: Filter distinct Count() for only a condition

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

Best,

Sunny

d_caprelli
Contributor II

Re: Filter distinct Count() for only a condition

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

d_caprelli
Contributor II

Re: Filter distinct Count() for only a condition

Hi i upload the project hope it can be open

thanks

d_caprelli
Contributor II

Re: Filter distinct Count() for only a condition

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

asilveira
New Contributor

Re: Filter distinct Count() for only a condition

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

d_caprelli
Contributor II

Re: Filter distinct Count() for only a condition

no is not that

d_caprelli
Contributor II

Re: Filter distinct Count() for only a condition

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 ?