How to show in dimension using class function all the lablels include null value

[eliko_il]

hi all,

I have histogram chart using the class function as the dimension and i want to disply all the classes not only those with actual value.

In the chart properties the show all value is selected.

thnx.

[kaushiknsolanki]

Hw can it show you the sales value which you had told qlikview to exclude.

Try this expression,

count(if(Sales<4000 and Sales>5000,0,Sales)

Regards,

Kaushik solanki  

[eliko_il]

OK thnx for the quick answer.

[kaushiknsolanki]

If you got the answer.

Kindly close the post.

Regards,

Kaushik Solanki