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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

How to hide expression depending on condition . ?

Hi All ,

Please kindly assist me , how to implement condition on expression ,

say for eg ,

if a dealer Name (Renault Paarl ) is open for bank - 'Wesbank' and 'MFC','STANDARD BANK' , then it will show on the three bank values in Main DIC report , the ABSA , ARIVA and SA Taxi column will be hidden.

8352  Wesbank

8356  MFC

8347 STANDARD BANK

8321 ABSA

21667 ARIVA

16575 SA Taxi

Capture.PNG

sample model attached.

11 Replies
sunny_talwar

Here you go... use this for color

if(PayOutReceived_Deal_Bank='Wesbank',(if(Alt([Wesbank DIC], 0) > Alt([MFC DIC], 0),if(Alt([Wesbank DIC], 0) > Alt([ABSA DIC], 0),if(Alt([Wesbank DIC], 0) > Alt([SBSA DIC], 0),if(Alt([Wesbank DIC], 0) > Alt([ARIVA DIC], 0),if(Alt([Wesbank DIC], 0) > Alt([SA Taxi DIC], 0),Green(),Red()),Red()),Red()),Red()),Red())),

    if(PayOutReceived_Deal_Bank='MFC',(if(Alt([MFC DIC], 0) > Alt([Wesbank DIC], 0),if(Alt([MFC DIC], 0) > Alt([ABSA DIC], 0),if(Alt([MFC DIC], 0) > Alt([SBSA DIC], 0),if(Alt([MFC DIC], 0) > Alt([ARIVA DIC], 0),if(Alt([MFC DIC], 0) > Alt([SA Taxi DIC], 0),Green(),Red()),Red()),Red()),Red()),Red())),

      if(PayOutReceived_Deal_Bank='ABSA',(if(Alt([ABSA DIC], 0) > Alt([Wesbank DIC], 0),if(Alt([ABSA DIC], 0) > Alt([MFC DIC], 0),if(Alt([ABSA DIC], 0) > Alt([SBSA DIC], 0),if(Alt([ABSA DIC], 0) > Alt([ARIVA DIC], 0),if(Alt([ABSA DIC], 0) > Alt([SA Taxi DIC], 0),Green(),Red()),Red()),Red()),Red()),Red())),

          if(PayOutReceived_Deal_Bank='SBSA',(if(Alt([SBSA DIC], 0) > Alt([Wesbank DIC], 0),if(Alt([SBSA DIC], 0) > Alt([MFC DIC], 0),if(Alt([SBSA DIC], 0) > Alt([ABSA DIC], 0),if(Alt([SBSA DIC], 0) > Alt([ARIVA DIC], 0),if(Alt([SBSA DIC], 0) > Alt([SA Taxi DIC], 0),Green(),Red()),Red()),Red()),Red()),Red())),

            if(PayOutReceived_Deal_Bank='ARIVA',(if(Alt([ARIVA DIC], 0) > Alt([Wesbank DIC], 0),if(Alt([ARIVA DIC], 0) > Alt([MFC DIC], 0),if(Alt([ARIVA DIC], 0) > Alt([ABSA DIC], 0),if(Alt([ARIVA DIC], 0) > Alt([SBSA DIC], 0),if(Alt([ARIVA DIC], 0) > Alt([SA Taxi DIC], 0),Green(),Red()),Red()),Red()),Red()),Red())),

              if(PayOutReceived_Deal_Bank='SA Taxi',(if(Alt([SA Taxi DIC], 0) > Alt([Wesbank DIC], 0),if(Alt([SA Taxi DIC], 0) > Alt([MFC DIC], 0),if(Alt([SA Taxi DIC], 0) > Alt([ABSA DIC], 0),if(Alt([SA Taxi DIC], 0) > Alt([SBSA DIC], 0),if(Alt([SA Taxi DIC], 0) > Alt([ARIVA DIC], 0),Green(),Red()),Red()),Red()),Red()),Red()))))))))

suvechha_b
Creator III
Creator III
Author

Thank you very much Sunny ... Its working 100 % .... Much appreciated.

Please kindly can I request for the below issue.

Please kindly assist me on the below requirement .