Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
suresh_cholleti
New Contributor

How to hide all measures where all columns of Dimension are reflecting Zero in Pivot Table (Charts) of Qlik Sense Desktop

Hi

Please let me know how to hide measures for which values are reflecting Zero for all Columns in Dimensions.

As per Screenshot,

BSName is Dimension (Field)

Sum(*****) are measures where **** are fields

where **** represents are multiple Fields as mentioned in screesshot.

My requirement is

I want to hide measure where all values are reflecting Zero in all BSnames

Ex : Sum(InterEnbOutQosFailTimerExp) is reflecting Zero for all three columns. It should not be displayed in Pivot table.

I have untick Zero values in Add-ons tab but couldnt helpful.

Thanks

Suresh

7 Replies
Partner
Partner

Re: How to hide all measures where all columns of Dimension are reflecting Zero in Pivot Table (Charts) of Qlik Sense Desktop

This is happening because the values are not exact 'zero' they might be for eg: 0.2 or 0.6 etc

To resolve apply a condition that the values must be greater than one or change the number formatting of the measure value.

Regards,

Ashwin.R

suresh_cholleti
New Contributor

Re: How to hide all measures where all columns of Dimension are reflecting Zero in Pivot Table (Charts) of Qlik Sense Desktop

No.. I'm sure that.. all Fields has Zero values only because that particular fields never report decimal values.

Anyhow I have applied following expression in measure to check, Still its not showing Zero Value & all the values are suppressed, refer below snapshot for the same.

if(Sum(InterEnbOutQosFailTimerExp)<>0,Sum(InterEnbOutQosFailTimerExp))@

Qlik2.PNG@

suresh_cholleti
New Contributor

Re: How to hide all measures where all columns of Dimension are reflecting Zero in Pivot Table (Charts) of Qlik Sense Desktop

Please someone look in to this..

balabhaskarqlik
Honored Contributor

Re: How to hide all measures where all columns of Dimension are reflecting Zero in Pivot Table (Charts) of Qlik Sense Desktop

May be:

Modify the measure something like this:

Aggr(if(not isnull(num(firstsortedvalue(aggr(sum(Measure),SBname),-  Aggr(sum(Measure),SBname),'#,##0' )),SBname),SBname))

Un-check "Include Zero values" in Add-ons tab won't work for this scenario.

suresh_cholleti
New Contributor

Re: How to hide all measures where all columns of Dimension are reflecting Zero in Pivot Table (Charts) of Qlik Sense Desktop

Hi

Thanks for the revert & still its not working, Expression is working fine after making some changes as below.

Aggr(

if(

    not isnull(num(firstsortedvalue(aggr(Sum(UeAssocS1ConnestabFailRNwUnspecified),BSName),

        -Aggr(Sum(UeAssocS1ConnestabFailRNwUnspecified),BSName),'#,##0')),BSName),BSName

       ),BSName

  )


Capture_4.PNG


My requirement is , It should the row should not be displayed when there are all Zeros.


Please check


Thanks in Advance


@Bala Bhaskar

imhappiee
New Contributor III

Re: How to hide all measures where all columns of Dimension are reflecting Zero in Pivot Table (Charts) of Qlik Sense Desktop

have you tried removing the filter on Dimension to include null values ?

suresh_cholleti
New Contributor

Re: How to hide all measures where all columns of Dimension are reflecting Zero in Pivot Table (Charts) of Qlik Sense Desktop

Hi

In dimension, I never applied any filter and unticked values on Include Null values under dimension.

Still no luck.

Thanks