Set analysis

[Anonymous]

Hello!

I would like to know if it´s possible to show in a graph a value of a dimension wich is restricted in the set analysis.

For. Example:

I want to know the number of agents thath sold something in June

Count(${<Month={'June'}>}Agent)

But, even if an agent did 0 sales in June, I would like to show it in the table with a 0.

I tried checking the option in presentation os "Delete 0 values".

But my agent with 0 sales doens´t show.

[adamdavi3s]

Is the data really 0 or is it missing?

If it is populated in the table as 0 then this should work (unchecking supress 0 values) but if there is no record for an agent in June then it won't show at all.

You should add this 'missing' data to the table as a 0 value to make it work

Generating Missing Data In QlikView

[Anil_Babu_Samineni]

Assume, you have data like below

LOAD * Inline [

MonthName, Agent

Jan, AAG1

Feb, AAG2

Mar, AAG3

Apr, AAG4

May, AAG5

Feb, AAG6

Mar, AAG7

Jun, AAG8

Jun,

Jun, AAG10

Nov, AAG11

];

From Here, For JUN you want to see 2 / 3 ??

If it is 2 -- Count({<MonthName = {'Jun'}, Agent -= {''}>}Agent)

If it is 3 -- Count({<MonthName = {'Jun'}>}Agent)

[vinieme12]

uncheck, suppress zer values and in dimension tab, check show all values

[ahaahaaha]

Hi Guillermo

Maybe character $ after the brace?

Count({$<Month={'June'}>}Agent)

Regards,

Andrey

[vinieme12 · Accepted solution]

Show all values in dimension should work, but here's another trick

Modify expression to multiply by avg(1)

= Count(${<Month={'June'}>}Agent) * AVG(1)

[Anonymous]

Uooh! funny trick hahaha, it worcked very well!!

Thank you very much Vineeth.!!