filtered straigth table with expressions

[Anonymous]

Hello,

I stuck currently in a maybe simple question.

I have a straight table with several dimensions and expressions.

When I filter the straight table by a criteria I get only those lines where the expression has a result.

But the whished result is a list which shows all lines, also lines with null values from the expressions.

I tried already to deactivate the settings for "display zero values" within the dimension and presentation tab.

And when I try to use an expression like

count ( {1 < CONTACT = {'visit'}   >} [CONTACT] )

the filter value is completely ignored.

Many thanks in advance for your help and best regards,

Claus

[Anonymous]

Many thanks, now I get it!

I moved the dimension city into the expressions ( =only(city)  ) and know I get also the zero lines displayed!

Best regards,

Claus

[ogautier62]

thanks

ok good dev

[Anil_Babu_Samineni]

I hope He got answer

[Anonymous]

I do, many thanks also for your answer!

BR,

Claus