Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

evgeniystuchalk
Contributor 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
sureshqv
Esteemed Contributor III

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

means?

your measure =sum(sales)    result 100 

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

sureshqv
Esteemed Contributor III

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

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

evgeniystuchalk
Contributor II

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

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.

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

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

Community Browser