topic data range selection issue in QlikView

data range selection issue

Wed, 20 Jan 2016 16:26:57 GMT

Hi experts ,

I have to age field which having age values 15-30, i am using two input variables min, max and apply button.

in variable if i select less than 15 age, chart have to display no data .give me your possible ways to achieve this.

Regards,

Mike

Re: data range selection issue

swuehl — Wed, 20 Jan 2016 17:20:36 GMT

You can use a calculation condition on general tab:

=min >= 15 AND max >= 15

Re: data range selection issue

Wed, 20 Jan 2016 17:56:30 GMT

hi swuehl,

Thanks for your reply, as you mention calculation condition not match it will show calculation unfulfilled. but same way chart have to show no data to display instead of calculation condition unfulfilled,is it possible with alt function? .

alt(if(min>=15 and max>=15), 'no data ')

Regards,

Mike

Re: data range selection issue

swuehl — Wed, 20 Jan 2016 18:00:52 GMT

On general tab, 'Error messages' button will open a dialog to adjust the error message to whatever you want.