Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Not applicable

How to set default setting for bar chart

Hi all,

Do anyone have any idea  how to set the default setting of a bar chart? Usually after we had created a bar chart and we clear the all the field there is some default values in the bar chart. Is it possible to set the bar chart to a default setting. Meaning to say if we do not click on anything from the list box, the bar chart will remain blank, there will only be values in the bar chart if we have made selection in the list box.

@

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: How to set default setting for bar chart

Onw way is what Manish suggested , you can hide your chart conditionally.

If you don't want to hide the chart but just make the data unavailable when there is no selection then you can use the "Calculation condition".

Go to Chart Properties--General Tab.

In Calcualtion condition give the selections that you want the chart to displayed upon.

For Ex:

Say your list box has a field called Month then

Month = 'Dec'

You can use multiple selections here per your requirements. This way when nothing is selected, the chart will be available but will be blank and show a message as "Calculation condition unfulfilled".

Hope this helps!

View solution in original post

10 Replies
Highlighted
MVP
MVP

Re: How to set default setting for bar chart

Why dont you hide the bar chart with conditional show?

something like below...

Go to Layout Tab of your bar chart properties

Under Show Conditional write below..

=NOT ISNULL(GetCurrentSelections())

Highlighted
sunilkumarqv
Valued Contributor II

Re: How to set default setting for bar chart

You mean like this

Highlighted
Not applicable

Re: How to set default setting for bar chart

Onw way is what Manish suggested , you can hide your chart conditionally.

If you don't want to hide the chart but just make the data unavailable when there is no selection then you can use the "Calculation condition".

Go to Chart Properties--General Tab.

In Calcualtion condition give the selections that you want the chart to displayed upon.

For Ex:

Say your list box has a field called Month then

Month = 'Dec'

You can use multiple selections here per your requirements. This way when nothing is selected, the chart will be available but will be blank and show a message as "Calculation condition unfulfilled".

Hope this helps!

View solution in original post

Highlighted
Partner
Partner

Re: How to set default setting for bar chart

Hi,

Please find in attachment.

And also through Ad hoc reporting we can find the result.

Highlighted
Not applicable

Re: How to set default setting for bar chart

Thanks Manish, it works. But let say if I want to just dsplay just the bar chart without any values when no selection has been made, is it possible?

Highlighted
Not applicable

Re: How to set default setting for bar chart

Thanks Sunil for your reply, I am currently using the Personal Edition of Qlikview and is unable to see your attachment. Is it possible to paste your expression? Thanks!

Highlighted
Not applicable

Re: How to set default setting for bar chart

Thanks Shyamal for your reply. It works!

Highlighted
Not applicable

Re: How to set default setting for bar chart

Thanks jsingh for your reply!

Highlighted
MVP
MVP

Re: How to set default setting for bar chart

Yes.

Create two same bar chart....

1st Bar Chart

Untick Value on data points from Expression tab

Go to Layout Tab of your bar chart properties

Under Show Conditional write below..

=ISNULL(GetCurrentSelections())

2nd Bar Chart   

tick Value on data points from Expression tab

Go to Layout Tab of your bar chart properties

Under Show Conditional write below..

=NOT ISNULL(GetCurrentSelections())

Now Put one chart on the second chart...

Update:

Please check enclosed file.