display fields wich are not associated

[#1]

Hello,

I explain my problem , i ve an table with some indicators and some dimension (Id_articles,Designation,etc...)

I would like for an selection which gives any result  to display all the dimension; all the id_articles , designations even if they don't give result with the indicator..

Is that possible ?

thanks

[alexandros17]

Write only 1 expression, in which you write 1 (One)

let me know

[#3]

thanks for your answer but i don t understand...i try to put

only(sum(indicator)) but it doesn't work ...

is that ?

[jonasheisterkam]

Use =' ' or =1 or any other value but with now connection to your data, so it woud be shown for each Dim kombination. In a Straight table you can  then hide the column under presentation.

[#5]

In a chart? If I understood a question,

To show dimension regardless of selections - check box "Show all values" on that dimension.

To show rows with zeros - uncheck box "Suppress zero-values" on presentation tab.

Your mentioned expression is not correct - "sum" and "only" are both aggregate functions and do not need to be cascaded.

[#6]

yes thanks,

i try to be more explicit, if you look the screen i join,

you will see the problem, i have selectioned an date for this date i ve some article which have been sold so for this article there no problem i ve the designation and the id_article and the result of my indicator...

But i would like to have in the same chart the article wich have not been sold and for them the designation the problem if you look my chart i can't get the designation of the article....

my  expression in my chart is  :

if(isnull(sum(Amount)) or sum(Amount)=0,'X',sum(Amount))

[#7]

if i put only one dimension in my chart it's working as you could see on the picture joined but if i want to have an second dimension it doesn't work , i ve no values ..

How is it possible and how could i do to have more than one dimension if the indicator is null ?

[#8]

I tried do it on example, but failed...

[#9]

it looks like an bug, is there any people from qliktech or others who met this kind of problem ?