topic Need help in expression in QlikView

Need help in expression

Fri, 01 Feb 2013 13:03:07 GMT

Hello Friends,

As I need to dispaly the text in a text box based on selection, the text color shoud change.

I tried =If(vFiscal<>1,Blue('Current View is Calendar Months'),Red('Current View is Fiscal Period')), but its showing the color code.

Regards

Chriss

Re: Need help in expression

Gysbert_Wassenaar — Fri, 01 Feb 2013 13:33:42 GMT

You'll have to set the color for the text on the Font tab. Click on Color and check the option Calculated and enter the expression =if(vFiscal<>1, blue(), red()). Your expression for the text would be =If(vFiscal<>1,'Current View is Calendar Months','Current View is Fiscal Period')

Re: Need help in expression

Fri, 01 Feb 2013 14:17:54 GMT

Hi Gysbert,

Thanks a lot, you genious helped me lot.

great work.

Regards

Chriss