topic Null in calculated dimension in table in QlikView

Null in calculated dimension in table

ester_pr — Mon, 11 Jul 2011 13:44:18 GMT

Hi,

I have tryed to calculated dimension in pivot table to put Null values when ever ther is Null in one Expression

it lokes like that if(isnull(sales),null(),customer)

I get only the customers that have sales but when ever I write other Expressions thay don't give the right results.

is ther a way to write that dimension is customer and not only to put the customer name?

or if ther is another solution to my problem?
thanks,

Null in calculated dimension in table

erichshiino — Tue, 12 Jul 2011 00:41:42 GMT

I belive it's easier if you post some sample data.

... What kind of differeces did you find?

maybe your dimension could be:

aggr( if( sum(Sales) <> 0, customer), customer)

Or... you could use an if on each expresson:

= if( sum(sales)<>0, sum(budget))

Hope this helps,

Erich

Null in calculated dimension in table

ester_pr — Tue, 12 Jul 2011 05:10:55 GMT

Thank you Erich you have been very helpful

Ester

Null in calculated dimension in table

ester_pr — Tue, 12 Jul 2011 13:22:24 GMT

Hi,

naw I am trying to exclude in gauge tha sales to which there are no guals, but when ever i do'nt choose customer the sum is for all, including these with no gouls

the same for chart

I have tride aggr but stil, in sum all does'nt work

tanks,

Ester