calculated dimension with If(count..

[#1]

Hi Guys!

I have some problem with calculated dimension in Bar Chart.

My dimension is =If ( count (distinct [Month]) = 1, [First Dimension], [Second Dimension])

It's so simple, but i can't understand why it's dont work.

I use QlikView 9.

Thank for response!

[#2 · Accepted solution]

My first thought is that the problem is with your expression.

You probably have a sum() function or something. The data that is in your expression, is that consistant with both dimension 1 and dimension 2?

You could try to re-program your expresseion to be a aggr() function - that sometimes works better with calculated dimensions.

Maybe if you can post an example it will help. I use calculated dimensions also, with varied success.

Another ay to solve it is to make i drill-down group, maybe?

[#3]

Thank for answer!

I already find solution, don't know how, but Groups realy work, and do what i need.)

Yes, it was Sum() and it work with both dimension.

Yes I try to use Aggr, it don't work correctly.

Realy thanks for reply!

I'm beginner in QlikView, and it forum is only way to get some information.