Discussion Board for collaboration related to QlikView App Development.
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
Thanks in Advance
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.
View solution in original post