Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@
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!
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())
You mean like this
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!
Hi,
Please find in attachment.
And also through Ad hoc reporting we can find the result.
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?
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!
Thanks Shyamal for your reply. It works!
Thanks jsingh for your reply!
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.