Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

arpitkharkia
New Contributor II

Hide measure w.r.t one dimension in Pivot table

I have a pivot table with two dimensions Memo_Key and Timezone. I want to display total calls with respect to  dimensions and total but the measure Timezone efficiency should be displayed at totals only. Is there any way to hide the timezone efficiency measure for each of the timezone dimension bucket?

3 Replies
laddu_927
Valued Contributor

Re: Hide measure w.r.t one dimension in Pivot table

Use calculated dimension If(Match(Dimension,'Total Calls'),Dimension)

Re: Hide measure w.r.t one dimension in Pivot table

Can you share the expected layout please. Meantime, please share excel file with us

Re: Hide measure w.r.t one dimension in Pivot table

Try with Dimensionality() function like

if(Dimensionality()=0, count(TotalCalls), effieciency expression)

Community Browser