Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
azmeerrehan
Partner - Creator
Partner - Creator

Display Same Value in All Cells of Straight Table

Attached please find the sample qvw and excel file.  I have a straight table with 2 dimensions.  I am doing a simple sum of Sales.

My dimensions are Variety and Zone.  All zones have 0 sales but "Null" Zone has a value of 30.  I would like to show the value "30" in all Zones.

Can't seem to make it work.  Any help is appreciated

2 Replies
m_woolf
Master II
Master II

Sum(TOTAL Sales)

azmeerrehan
Partner - Creator
Partner - Creator
Author

Already tried that,it does not work because it will sum everything, I want the total at the variety level, so for example if I have variety No 2, it will  have seperate total values for variety 1 and 2