Discussion board where members can get started with QlikView.
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,
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,
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