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
danosoft
Specialist
Specialist
Author

is the same, in the text box the value is: 13

sunny_talwar

So you set analysis is actually doing this

Count(DISTINCT {<ANNO_EMI = {"$(=Num(13, '00'))"}>} PDR)

This is because set analysis is evaluated once per chart. So the value you see in text box object, is the value used in the set analysis for the whole chart. May I know the reason you expect to see 2 + 1?

danosoft
Specialist
Specialist
Author

but i not want to set 2 + 1 i want to set: MESE_COMPETENZA + 1

but it not start....

sunny_talwar

Don't think I understand. Sorry my friend

danosoft
Specialist
Specialist
Author

my problem i need to put a chart where my value of Budget line is my MESE_EMISSIONE = MESE_COMPETENZA +1

sunny_talwar

Oh okay, try this

Above(Count(DISTINCT PDR))

sunny_talwar

Or this

Before(Count(DISTINCT PDR))

danosoft
Specialist
Specialist
Author

but there i not see the filed MESE_EMISSIONE e MESE _COMPETENZA (those are columns in my table)

danosoft
Specialist
Specialist
Author

thanks but i sent all from the first post.........