topic Re: How to show in dimension using class function all the lablels include null value in QlikView

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

eliko_il — Mon, 11 Mar 2013 08:44:42 GMT

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.

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

Gysbert_Wassenaar — Mon, 11 Mar 2013 08:58:49 GMT

Try unchecking the option Suppress Zero-Values on the Presentation tab of the properties window too. And probably enable the Suppress When Value Is Null for the dimension. See attached qvw.

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

eliko_il — Mon, 11 Mar 2013 09:07:07 GMT

Still not working, any other ideas?

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

kaushiknsolanki — Mon, 11 Mar 2013 09:08:30 GMT

Hi,

Kindly please upload the qvw file.

Regards,

Kaushik Solanki

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

eliko_il — Mon, 11 Mar 2013 09:38:38 GMT

Hi,

I can't upload my file cuz confidential reasons, but im upload picture from Gysbert Wassenaar file above with one change,

insted using the class function in the script im using it as calculate dimenson (=class(sales)) and because of

that i can't display the classes with no data(the missing class is 4000 <= x <= 5000).

I have to use the class function in the calculate dimension and no in the script cause the cluster size changing

dynamic according user input.

thnx.

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

kaushiknsolanki — Mon, 11 Mar 2013 09:42:18 GMT

Have you deselect the "Suppress Zero Values" as suggested by Gysbert Wassenaar?

You will find it under presentation tab.

Regards,

Kaushik Solanki

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

eliko_il — Mon, 11 Mar 2013 09:51:57 GMT

Yes, already done it, still dont work.

p.s

how can i attach file here the only optin i see is pucture video or link?

thnx.

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

kaushiknsolanki — Mon, 11 Mar 2013 09:54:48 GMT

You can see the option "Use Advanced Editor" when you reply to the post.

Regards,

Kaushik Solanki

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

eliko_il — Mon, 11 Mar 2013 09:58:25 GMT

Ok thnx, im attach the file.

Please see if you can help.

thnx.

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

kaushiknsolanki — Mon, 11 Mar 2013 10:01:24 GMT

HI,

The problem resides in your expression.

your expression is

count({<Sales={'<4000>5000'}>}Sales)

Here you are saying that give the sales where sales is not between 4000 and 5000

Regards,

Kaushik Solanki

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

kaushiknsolanki — Mon, 11 Mar 2013 10:06:52 GMT

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

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

eliko_il — Mon, 11 Mar 2013 11:25:56 GMT

OK thnx for the quick answer.

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

kaushiknsolanki — Mon, 11 Mar 2013 11:29:13 GMT

If you got the answer.

Kindly close the post.

Regards,

Kaushik Solanki