topic Re: How to stop the expression adding the values in the column in QlikView

How to stop the expression adding the values in the column

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

Hi ,

I have a table with month/year, message end point, message received etc;

As you can see for the month/year March 2015 , there are 2 message end points which I have to hide it for confidentiality and consequently the message received column is splitting the (4 + 5) = 9 in the 3rd row of Month /year (march 2015).

My requirement is how to stop the green bit i have highlighted in the picture.

I have tried some options in the expression not to do that activity but cant stop that coming on to the table.

Any help pls.

regards,

Vamsi.

Re: How to stop the expression adding the values in the column

vinieme12 — Thu, 19 Jan 2017 12:43:19 GMT

Can you attach a sample, also there is no picture!

Re: How to stop the expression adding the values in the column

Anonymous — Thu, 19 Jan 2017 12:44:19 GMT

sorry i forgot to do that earlier.

But i did just now pls check.

Re: How to stop the expression adding the values in the column

Anonymous — Thu, 19 Jan 2017 12:49:29 GMT

Re: How to stop the expression adding the values in the column

sunny_talwar — Thu, 19 Jan 2017 12:55:54 GMT

Is this a straight table? and if it is, is Message_Endpoint a dimension? If both these things are true, then you can check 'Suppress When Value Is Null' on the dimension tab for your Message_Endpoint dimension....

Re: How to stop the expression adding the values in the column

Anonymous — Thu, 19 Jan 2017 12:59:55 GMT

Yes sunny, message_end point is a dimension and it is a straight table.

Let me try that,.

super .....great thanks sunny. it worked.

Re: How to stop the expression adding the values in the column

sunny_talwar — Thu, 19 Jan 2017 13:01:53 GMT

Great, please close this thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny