Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
evgeniystuchalk
Partner - Creator II
Partner - Creator II

Qlik Sense - how to hide measure in columns, but keep it in totals?

Hello! I need this:

839805424c.jpg

How i can achieve it? Extensions? CSS tricks? Some unknown Qlik Sense functional?

4 Replies
Chanty4u
MVP
MVP

means?

your measure =sum(sales)    result 100 

so you want to see    -    sum(sales)100    ?

Chanty4u
MVP
MVP

or you can give the  measure  label  dot  "."     only single dot ?

evgeniystuchalk
Partner - Creator II
Partner - Creator II
Author

I want create Pivot Table with two measures: sum(sales) and count(sales). measure count(sales) must be visible only in total column, and hided in dimension columns.

Anonymous
Not applicable

Have a look at the Qlik Dimensionality() function.

How to use - Dimensionality()      Don't worry that this is re QlikView, the function works the same in QlikSense

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/InterRecordFun...

You should be able create colour expressions to set the Text and Background Colours dependant on the Dimensionalities you wish to hide as white on white