topic Removing Data From Text Box in QlikView

Removing Data From Text Box

Wed, 30 Nov 2011 12:36:25 GMT

Hi,

I have a text box which displayes the following data: Oracle, Password Reset, Cyborg and STW. The information comes from and excel file called software in which there is a tab called Summary. I want to remove Password Reset from the text box and keep Oracle, Cyborg and STW.

I have tried entering the following statement in the Calculation Condition section in the General Tab, but I get a message saying: Calculation Condition Unfulfilled.

=IF(Software.Software='Password Reset',0,Sum(Software.Software))

Removing Data From Text Box

johnw — Thu, 01 Dec 2011 00:19:13 GMT

The answer is probably easy, but I seriously don't understand the question. A calculation condition is almost certainly not what you want, though. What are you actually displaying in the text box? What's the expression for the text itself? What do you see? What do you want to see instead?

Removing Data From Text Box

Thu, 01 Dec 2011 08:24:17 GMT

If you are talking about a filter box then it is just:

=IF(Software = 'Password Reset', null(), Software)

Then click the suppress null values check box. If you are talking about a dimension in a pivot table then do the same.

If you are trying to calulate some value in a pivot table with Software as the dimension you can do the above or you can set the dimension as Software and then do:

=SUM(IF(Software = 'Password Reset', 0, ValueToBeSummed))

Then suppress zero values.