Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello everyone
I have a bar chart with three dim and one expression
for dim1 there are two value in dim2
example
Dim1 Dim2 Sales
a open 100
a closed 200
b open 300
c open 220
c closed 100
now in bar graph on x axis i am getting two bars wrt to 'a' ie open and closed
but for 'b' also two bars comes one for open and for closed it shows zero bar
I want to restrict this zero bar.. it should show only OPEN for B
I have tries all features
suppress null
zero bars etc
kindly advice what needs to be done
Thanks
May be this
Can you please share the sample app
If you want to show Zero value on Chart :
Data:
NoConcatenate Load
district,
RangeMax(0.00000001, count) as count
resident Data_Raw;
Assuming the Data_Raw table contains your original raw data.
And use the num(Sum(count), '##0') as Measure in your Pie-Chart.
It produces the results you need (district FFFF contains 0 counts, but still represented on the chart):
And if you don't want zero values
Properties --> Presentation Tab --> Suppress Zero Values (Check that box)
For Web Qlik Sense, we can do by "Add-ons"--> "Data Handling" --> "Include Zero values" to hide zero values bars.