Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
Creator III

Dont show rows

hi All,

In the below table i am displaying a data related to severity, created, summary etc.

My requirement is to show only those rows where Counts is 1 and i dont need to show other blank rows ,\

I tried to suppress the dimension too but this is not working how do i get this done,

The formula for Counts is (If(sum(count)>0,sum(count),'')

Can you expertise please help on this .

Currently this table is diplaying format as shown in the snapshot suppress .PNG

Thanks in Advance

1 Solution

Accepted Solutions
jaibau1993
Partner
Partner

Hi!

Try modifying all your expressions like

"if( sum(Count) = 1, your expression here)"

Since the calculation sum(Count) is already being done, you may use something like

"if( Column(Number) = 1, your expression here)"

Where Number is the column number of the "Counts" expression.

Regards,

Jaime.

View solution in original post

1 Reply
jaibau1993
Partner
Partner

Hi!

Try modifying all your expressions like

"if( sum(Count) = 1, your expression here)"

Since the calculation sum(Count) is already being done, you may use something like

"if( Column(Number) = 1, your expression here)"

Where Number is the column number of the "Counts" expression.

Regards,

Jaime.

View solution in original post