Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
d_caprelli
Contributor II

Re: Filter distinct Count() for only a condition

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

MVP
MVP

Re: Filter distinct Count() for only a condition

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?

d_caprelli
Contributor II

Re: Filter distinct Count() for only a condition

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

but it not start....

MVP
MVP

Re: Filter distinct Count() for only a condition

Don't think I understand. Sorry my friend

d_caprelli
Contributor II

Re: Filter distinct Count() for only a condition

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

MVP
MVP

Re: Filter distinct Count() for only a condition

Oh okay, try this

Above(Count(DISTINCT PDR))

MVP
MVP

Re: Filter distinct Count() for only a condition

Or this

Before(Count(DISTINCT PDR))

d_caprelli
Contributor II

Re: Filter distinct Count() for only a condition

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

MVP
MVP

Re: Filter distinct Count() for only a condition

d_caprelli
Contributor II

Re: Filter distinct Count() for only a condition

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