Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
arpitkharkia
Creator III
Creator III

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
Anonymous
Not applicable

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

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
settu_periasamy
Master III
Master III

Try with Dimensionality() function like

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