topic Re: display row only if all row populated in QlikView

display row only if all row populated

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

How will I display only rows that have both data in Try and Win rows?

so I am after:

Thanks

Raphael

vishsaggi — Thu, 02 Nov 2017 13:47:00 GMT

Check attached.

sunny_talwar — Thu, 02 Nov 2017 13:47:14 GMT

Use the same if statement that you used for your third expression within the 1st and 2nd expression

=if(Try>0 and Win>0, Try)

=if(Try>0 and Win>0, Win)

Anonymous — Thu, 02 Nov 2017 13:49:43 GMT

Thank you

Anonymous — Thu, 02 Nov 2017 13:52:30 GMT

Put your condition as a calculated dimension rather than name:

=if(Try>0 and Win>0, Name)