Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
jvk_sharma
Creator III
Creator III

How to stop the expression adding the values in the column

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.

1 Solution

Accepted Solutions
sunny_talwar

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....

View solution in original post

6 Replies
vinieme12
Champion II
Champion II

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

jvk_sharma
Creator III
Creator III
Author

sorry i forgot to do that earlier.

But i did just now pls check.

jvk_sharma
Creator III
Creator III
Author

msgs.png

sunny_talwar

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....

View solution in original post

jvk_sharma
Creator III
Creator III
Author

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

Let me try that,.

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

sunny_talwar

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

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny