topic Re: How to hide expression depending on condition . ? in QlikView

How to hide expression depending on condition . ?

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to hide expression depending on condition . ?

olivierrobin — Thu, 31 May 2018 07:03:37 GMT

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

Re: How to hide expression depending on condition . ?

sunny_talwar — Thu, 31 May 2018 11:47:31 GMT

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?

Re: How to hide expression depending on condition . ?

suvechha_b — Thu, 31 May 2018 12:02:31 GMT

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.

Re: How to hide expression depending on condition . ?

sunny_talwar — Thu, 31 May 2018 12:18:34 GMT

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?

Re: How to hide expression depending on condition . ?

suvechha_b — Thu, 31 May 2018 12:19:50 GMT

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

Re: How to hide expression depending on condition . ?

sunny_talwar — Thu, 31 May 2018 12:23:42 GMT

May be check attached

Re: How to hide expression depending on condition . ?

suvechha_b — Fri, 01 Jun 2018 05:23:03 GMT

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 .

Re: How to hide expression depending on condition . ?

sunny_talwar — Fri, 01 Jun 2018 09:01:20 GMT

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

Re: How to hide expression depending on condition . ?

suvechha_b — Fri, 01 Jun 2018 09:06:54 GMT

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 .

Re: How to hide expression depending on condition . ?

sunny_talwar — Fri, 01 Jun 2018 09:13:37 GMT

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

Re: How to hide expression depending on condition . ?

suvechha_b — Fri, 01 Jun 2018 09:57:28 GMT

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 .