topic Re: the program values for resale. How to hide Customers without sales in a variable in QlikView

the program values for resale. How to hide Customers without sales in a variable

Ribeiro — Sat, 05 Dec 2020 11:26:59 GMT

In the image below, there is a Client Code that is showing the variable vFinanceiro. because I need to create a set analysis that doesn't come white.

The result I need should look like this.🤔

Re: the program values for resale. How to hide Customers without sales in a variable

Kushal_Chawda — Sat, 05 Dec 2020 15:59:52 GMT

@Ribeiro your qvw has section access. please remove and attach the new one

Re: the program values for resale. How to hide Customers without sales in a variable

rubenmarin — Sat, 05 Dec 2020 17:23:52 GMT

Hi @Ribeiro, one option is to add an if to each expression to check if(SalesExpression<>0, ThisColumnExpression)

Another option is a calculated dimension that does the check: Aggr(if(SalesExpression<>0, DimensionFieldName), DimensionFieldName)

Re: the program values for resale. How to hide Customers without sales in a variable

Ribeiro — Sat, 05 Dec 2020 18:20:17 GMT

Aggr (if ( Sum({$<[EFETIVADA]={'1'},[CANCELADA]={'0'},[EVENDA]={'1'},
[CODIGOTIPOMOVIMENTO]={'20','99','111','116','117'},[TIPOSAIDAENTRADA]={'S'}>}VALORTOTAL)
<> 0, VALORTOTAL), CODIGOPESSOA)

did not work🤔

Any suggestion.

empty🤣

Re: the program values for resale. How to hide Customers without sales in a variable

rubenmarin — Sun, 06 Dec 2020 17:10:11 GMT

Hi, the aggr option was to use as conditional dimension, instead of COD.

The version to reduce using expressions need to add the check in all the expressions, becasuse if any espression has a value to show, it will show the dimension, ie:

if ( Sum({$<[EFETIVADA]={'1'},[CANCELADA]={'0'},[EVENDA]={'1'},
[CODIGOTIPOMOVIMENTO]={'20','99','111','116','117'},[TIPOSAIDAENTRADA]={'S'}>}VALORTOTAL)
<> 0, VFinanceiro)

and for VALORTOTAL it should be:

if ( Sum({$<[EFETIVADA]={'1'},[CANCELADA]={'0'},[EVENDA]={'1'},
[CODIGOTIPOMOVIMENTO]={'20','99','111','116','117'},[TIPOSAIDAENTRADA]={'S'}>}VALORTOTAL)
<> 0, Sum({$<[EFETIVADA]={'1'},[CANCELADA]={'0'},[EVENDA]={'1'},
[CODIGOTIPOMOVIMENTO]={'20','99','111','116','117'},[TIPOSAIDAENTRADA]={'S'}>}VALORTOTAL))

If you only set "VALORTOTAL" as the true part of the 'if' it returns null because it has different VALORTOTAL values