Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression without total dimension

Hi everybody. My english is not good but i hope you can understand me.

I attached an image because I need your help. The fields "F. Desde", "F. Hasta" and "Notas" are only informative, i do not calculate with this fields. So I need show null value for the total by dimension to this fields.

Sin totales.jpg

In the picture are marked with red totals I want to display a null value.

I hope my explanation is understood.

Thanks all and regards.

Luciano Muñoz.-

1 Solution

Accepted Solutions
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi,

try using the Dimensionality() function, to check wether the expression is evaluating the value for a detail line or for a (sub)total line. Something like:

if(Dimensionality()=x, Fecha)

Hope this helps you

Fernando

View solution in original post

2 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi,

try using the Dimensionality() function, to check wether the expression is evaluating the value for a detail line or for a (sub)total line. Something like:

if(Dimensionality()=x, Fecha)

Hope this helps you

Fernando

Not applicable
Author

Thank you very much, this solve my problem.

Regards.

Luciano Muñoz.-