topic Re: Set analysis in QlikView

Set analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Set analysis

adamdavi3s — Tue, 14 Mar 2017 07:38:33 GMT

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

Re: Set analysis

Anil_Babu_Samineni — Tue, 14 Mar 2017 07:40:06 GMT

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)

Re: Set analysis

vinieme12 — Tue, 14 Mar 2017 07:40:13 GMT

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

Re: Set analysis

ahaahaaha — Tue, 14 Mar 2017 07:42:01 GMT

Hi Guillermo

Maybe character $ after the brace?

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

Regards,

Andrey

Re: Set analysis

vinieme12 — Tue, 14 Mar 2017 07:51:14 GMT

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)

Re: Set analysis

Anonymous — Tue, 14 Mar 2017 08:05:59 GMT

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

Thank you very much Vineeth.!!