Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Skip zero values while working with crosstable ?

I have a record with twelve amount fields, one for each month in the year. Some month have a zero amount.  I use a crosstable to split the fields in seperate records. The result is ok, but i get several records with an amount value of zero. Is there a way where i can skip the records which result in a zero value ?

0 Replies