condition on charts

[prma7799]

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

[Gysbert_Wassenaar]

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,...

[prma7799]

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

[prma7799]

PFA..

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

[Gysbert_Wassenaar]

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.