topic class/brackets show all in QlikView

class/brackets show all

Tue, 24 Nov 2009 15:44:33 GMT

Hi,

I'm trying to categorize values in classes. so far no problem.
instead of class I tried several if statements.

if(amount <20, '0-20', if(amount <41, '21-40',if(amount <61,'41-60', if(amount < 81,'81-100')))) AS Brackets

How can I show always all classes/brackets, also if they don't exist for the current selection?

Thanks for your help.

Aloah

Miguel_Angel_Baeyens — Tue, 24 Nov 2009 16:05:43 GMT

You should add an additional if statement controlling isnull(amount), i.e.:

if(not isnull(amount<20),(condition for not null amount<20),(condition for null amount<20))

Regards.

Tue, 24 Nov 2009 16:11:03 GMT

In Chart Properties -> Dimensions Tab, select Brackets dimension and check the flag "Show All Values"

Tue, 24 Nov 2009 16:11:11 GMT

In Chart Properties -> Dimensions Tab, select Brackets dimension and check the flag "Show All Values"