topic condition on charts in QlikView

condition on charts

prma7799 — Wed, 29 Jul 2015 11:58:38 GMT

Hi All,

I have one chart and for that i have to put condition when that condition will fulfill then then it will shows data.

I am trying to do but not get it .

I put below expression in calculated condition

(GetFieldSelections(FinancialYear)) >= '2013-2014' and (GetFieldSelections (Therapy)>0)

and i have to manmy dimension like therapy ,brand ,division,state etc.

Thanks

Re: condition on charts

Gysbert_Wassenaar — Wed, 29 Jul 2015 12:06:03 GMT

The problem with GetFieldSelections(FinancialYear)) >= '2013-2014' is that '2013-2014' is not a number but text. The >= operator does not work on text values. Perhaps you can use a condition like if(num#(right(FinancialYear,4))>2014,...

Re: condition on charts

prma7799 — Wed, 29 Jul 2015 12:11:29 GMT

Hi Gysbert,

Thanks for your reply but if i don't want use financial year and use only GetFieldSelections (Therapy,brand ....etc) so how to achieve it.

I created some buttons and give hide and show effect on that chart when i move to next sheet and do any selection then

my chart showing nothing then i have to select that button.

For that chart i want message for user that please select Therapy....etc.

Thanks

Re: condition on charts

prma7799 — Wed, 29 Jul 2015 12:15:55 GMT

PFA..

in this i have two attachment one is before any selection and second is after selection of next sheet.

Re: condition on charts

Gysbert_Wassenaar — Wed, 29 Jul 2015 12:30:38 GMT

No idea. I can't read your mind nor your qlikview document. If you can post a qlikview document that demonstrates the problem I can have a look at it. If not... then I'm afraid you'll have to figure it out yourself.