Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
guiecokey22
Contributor III
Contributor III

Set analysis

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.

1 Solution

Accepted Solutions
vinieme12
Champion II
Champion II

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)

View solution in original post

6 Replies
adamdavi3s
Master
Master

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vinieme12
Champion II
Champion II

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

ahaahaaha
Master
Master

Hi Guillermo

Maybe character $ after the brace?

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


Regards,

Andrey

vinieme12
Champion II
Champion II

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)

View solution in original post

guiecokey22
Contributor III
Contributor III
Author

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

Thank you very much Vineeth.!!