Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

condition on charts

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

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand
prma7799
Master III
Master III
Author

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
Master III
Master III
Author

PFA..

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

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand