topic Re: calculation condition in QlikView

calculation condition

Mon, 28 Jul 2014 08:12:34 GMT

How do I write a calculation condition that the graph should only be displayed when a city_name is selected.

And can I add a text when there is no graph that the user has to select a city first?

Kind regards,

Katleen

Re: calculation condition

Anonymous — Mon, 28 Jul 2014 08:30:18 GMT

Hi,

refer the Qlikview example of "Whats New in Qlikview 11" in Reports tab,

then u can understand easily..

Re: calculation condition

Mon, 28 Jul 2014 08:33:51 GMT

Hi Katleen,

you can use

getselectedcount(city_name)>0

as a calculation condition for the graph, then click the error messages, you can override the standard calculation condition message with your own

hope that helps

Joe

Re: calculation condition

Mon, 28 Jul 2014 08:37:23 GMT

Hi Katleen,

In the Layout tab, select the Show as Conditional -> "if(GetSelectedCount(City_Name)=0,0,1)".

In the general tab, under Error messages, you can add a text when there is no graph.

Thanks

Sabal

Re: calculation condition

SunilChauhan — Mon, 28 Jul 2014 08:42:12 GMT

in layout of chart properties

getselectedcount(cityfield)>=1

hope this helps

Re: calculation condition

Mon, 28 Jul 2014 08:44:08 GMT

You won't be able to do this from the layout, as that means the chart will not show at all, making the error message useless. Need to put it in as a general calc condition not a layout show/hide

edit: sorry I should add, that would work of course but would just need to create a textbox with your text display message then (so a bit more work)

Joe

Re: calculation condition

Mon, 28 Jul 2014 09:06:46 GMT

Agreed

Re: calculation condition

warrentk80 — Mon, 28 Jul 2014 09:36:44 GMT

To view an object (graph) only if at least one city is selected, you must go to the object properties tab and slide show options enable the functions and conditional type not isnull ([field name city]), thus making the object field is only visible if the city is selected.

I hope to signing helped.

Thank you

Andrea

Re: calculation condition

Mon, 28 Jul 2014 09:54:40 GMT

Sum({$<Measures={$(=only(fieldname))}>} dimension) write this experssion and go to the general tab click on error meesage and click the calculation condition full filled..then type the following sentence(select a city to display the chart).....