Solved: How to hide expression depending on condition . ? - Qlik Community

suvechha_b · ‎2018-05-31

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

sample model attached.

sunny_talwar · ‎2018-06-01

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()))))))))

View solution in original post

olivierrobin · ‎2018-05-31

hello

in your graph, in dimension tab, you can code an expression under the conditional check box

the column will be shown only if expression is true

sunny_talwar · ‎2018-05-31

I am not sure I am able to follow what you are aiming for... the six columns that you highlighed from Main DIC should hide? When should they hide? when you select RENAULT PAARL within Dealer.name?

suvechha_b · ‎2018-05-31

Hi Sunny ,

We got 6 banks below

8352 Wesbank

8356 MFC

8347 STANDARD BANK

8321 ABSA

21667 ARIVA

16575 SA Taxi

The requirement is if for dealer 'Renault Paarl' only Wesbank and MFC are open , thus the Main DIC report should only show value for the two bank and the other bank should not be there is the Main DIC report .

Another dealer 'Allen New ' is open for only ABSA thus he will only see for ABSA all the other bank should not reflect on the Main chart.

Hope this explain my requirement.

sunny_talwar · ‎2018-05-31

But is this based on selection in RENAULT PAARL? Because Dealer.name has multiple options

RENAULT PAARL

Active Motors

Active Motors Eldoraigne

Will you be selecting one of those and then the columns should show up?

suvechha_b · ‎2018-05-31

Yes correct . I will select RENAULT PAARL dealer and it will show Main DIC report for Wesbank and MFC

sunny_talwar · ‎2018-05-31

May be check attached

suvechha_b · ‎2018-06-01

Hi Sunny ,

Your logic is working . But Please kindly assist me , how to change the color as well.

So , the color should be green when Finance House Bank is having the highest DIC Amount . See as the below screenshot.

The row should be green.

Please assist.

Thanks .

sunny_talwar · ‎2018-06-01

I don't see this row in the sample you attached earlier... also, I don't understand the logic for the color?

suvechha_b · ‎2018-06-01

Ok... you can take the same sample .

The first three row should be green ,

Say for eg , the first row , the highest DIC lies in Wesbank and the finance bank is also Wesbank .