topic Re: How to set default setting for bar chart in QlikView

How to set default setting for bar chart

Wed, 12 Mar 2014 09:42:09 GMT

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.

Re: How to set default setting for bar chart

MK_QSL — Wed, 12 Mar 2014 09:49:55 GMT

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())

Re: How to set default setting for bar chart

sunilkumarqv — Wed, 12 Mar 2014 09:52:13 GMT

You mean like this

Re: How to set default setting for bar chart

Wed, 12 Mar 2014 09:56:33 GMT

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!

Re: How to set default setting for bar chart

jsingh71 — Wed, 12 Mar 2014 09:59:13 GMT

Hi,

Please find in attachment.

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

Re: How to set default setting for bar chart

Wed, 12 Mar 2014 10:00:15 GMT

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?

Re: How to set default setting for bar chart

Wed, 12 Mar 2014 10:01:42 GMT

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!

Re: How to set default setting for bar chart

Wed, 12 Mar 2014 10:12:22 GMT

Thanks Shyamal for your reply. It works!

Re: How to set default setting for bar chart

Wed, 12 Mar 2014 10:13:07 GMT

Thanks jsingh for your reply!

Re: How to set default setting for bar chart

MK_QSL — Wed, 12 Mar 2014 10:13:36 GMT

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.

Re: How to set default setting for bar chart

sunilkumarqv — Wed, 12 Mar 2014 10:25:36 GMT

Follow the steps below past into tour application try like this

example

//script

Data:

Load * inline

[

Column,values

A,2

B,4

C,5

];

create bar chart Column as dimesion and experssion as values

//layout Conditional

Go properties show conditional

=if(GetFieldSelections(values)>1,1,0)

make on listbox values

select any value then bars get to display if you make clear all then layout will disapper

Qctually prevoius one diff try this