Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have an aplication where there are 6 text block. When I push one of them, the aplication change the sheet (for example SH02). I want to change de color of the text block that I have push to a other color ( the 6 text block are the menu of the aplication). How can I do it? I think that the method is something like this
IF( sheet ID = SH12, RGB(255,65,35,33) but I dont know the correct form
Thank you.
Juan,
Find the attached qvw file for example. Is that you want?
If need more information on this, you can check the below
quickintelligence.co.uk/user-interface-design-qlikview/
quickintelligence.co.uk/qlikview-buttons/
Regards,
Siva
Dear Juan,
Kindly find attached file, I hope you are looking for that one.
Kind regards,
Ishfaque Ahmed
Hi Juan,
Check the attachment.
Dear Juan,
You were very close to the answer only you should write the expression in correct syntax,
Below is the sample syntax for the expression of single sheet that you can use.
=IF(GetActiveSheetId() = 'SH07', RGB( 255,65,35,33 ),RGB(your choice))
However you can write the same syntax for multiple sheets.
Hope this will help you
Have a good time..!
Thank you very much all of yours!
Just realized that I missed the attachment. here it is