topic Re: null values in QlikView

null values

master_student — Thu, 09 Nov 2017 08:32:58 GMT

Hello Guys,

I have a field that displays 0, i need to supress these values :

i checked supress null values in the presentation Tab

Here is my SLA Globale formula :

=Interval(Sum({<[Code Cas] = p({<[Statut Cas] = {'Fermé crédit', 'Fermé-remboursé', 'Fermé activation', 'Fermé BO', 'Fermé DT', 'Fermé Rétention', 'Fermé Rétention Client Perdu', 'Fermé Rétention Client Retenu'}>})>}TOTAL <[Code Cas], [Date création], [Statut Cas], PROVIDER_GRP_ID> Interval#(SLA_GLOBAL, 's')), 'm')

Re: null values

Anil_Babu_Samineni — Thu, 09 Nov 2017 08:37:27 GMT

One funny Solution

If([SLA Globale] >0, Interval(Sum({<[Code Cas] = p({<[Statut Cas] = {'Fermé crédit', 'Fermé-remboursé', 'Fermé activation', 'Fermé BO', 'Fermé DT', 'Fermé Rétention', 'Fermé Rétention Client Perdu', 'Fermé Rétention Client Retenu'}>})>}TOTAL <[Code Cas], [Date création], [Statut Cas], PROVIDER_GRP_ID> Interval#(SLA_GLOBAL, 's')), 'm'))

Re: null values

master_student — Thu, 09 Nov 2017 09:09:56 GMT

didn't work, i always have 0 values on SLA Globale

Re: null values

vineetadahiya12 — Thu, 09 Nov 2017 09:17:17 GMT

Hi,

If you are using a straight table, under Presentation tab there is an option to Supress Zero-Values.

This would help you.

Re: null values

master_student — Thu, 09 Nov 2017 09:20:15 GMT

yes I did that but didn't works

Re: null values

Chanty4u — Thu, 09 Nov 2017 09:30:10 GMT

try

=if(Measure<>0, Dimension, Null())

Re: null values

master_student — Thu, 09 Nov 2017 09:45:13 GMT

didin't work

Re: null values

prma7799 — Thu, 09 Nov 2017 09:54:07 GMT

Please share some sample app

or try

=if(len(SLA Globale )=0, Dimension, Null())