Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Bar Chart with static X-axis in Qliksense

Hi All,

I am facing an issue in fixing the range of X-axis on bar chart so that all the values will be visible after making selection from filter pane whether is available or not for that particular dimension.

 

Please find the attached screenshot of Bar chart which filtered the records on the basis of selection I made from filter pane.

Could someone help me in fixing the x-axis on bar chart irrespective of selection we made.

2 Replies
Highlighted
Partner
Partner

Hi Nikita,

What you need to do is use set analysis to exclude the x-axis. Use this formula:

Sum({$< Timestamp = >}Colli)

Now it won't change based on the time stamp, but will on all other selections.

Jordy

Climber 

Work smarter, not harder
Highlighted
Contributor
Contributor

Can you add more than 1 column to exclude? I have the following..

Count({1<[Message Response]={'Responded'}>} [Message Response]) / (Count({1<[Message Response]={'Responded'}>} [Message Response])+ Count({1<[Message Response]={'No Response'}>} [Message Response]))

I want to exclude ALL field selections from modifying my chart. but when I make a selection in a field called "Region", the chart updates.

I added two images. one for the chart with no selections in the fields and the other with "AMER" selected in the Region field.