If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Is it possible to have a dynamic Totals colum in a pivot table?
In this example I have the sales for two companies and a Totals colum.
If I only select one company I don't want to show the Totals colum as I will have two colums with the same data.
Thanks! It works as intended with this expression:
View solution in original post
You may try it with an extended expression, like:
if(count(distinct Company) = 1 and secondarydimensionality() = 0, null(), YourExpression)