Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ester_pr
New Contributor

Null in calculated dimension in table

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,

3 Replies
erich_shiino
Honored Contributor

Null in calculated dimension in table

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

ester_pr
New Contributor

Null in calculated dimension in table

Thank you Erich you have been very helpful

Ester

ester_pr
New Contributor

Null in calculated dimension in table

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

Community Browser