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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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