Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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