topic Re: Removing - (Hyphen) results with in a Text Object in QlikView

Removing - (Hyphen) results with in a Text Object

Mon, 29 Oct 2012 20:54:43 GMT

Hi, I have the following Expression calculating the result of the top value in a list of activities with values in a Text Object.

In my data there has been a - (Hyphen) transfered with all the results.

=FirstSortedValue(Response_Level_2, -aggr(sum({$<Question_List_ID={4},Response_Level_2>}Ans_Minutes),Response_Level_2))

How can I exclude the - (Hyphen) results from the results?

Thanks

Rob

Mon, 29 Oct 2012 21:12:39 GMT

Can you provide a sample file? What do you mean by the hyphen results?

Mon, 29 Oct 2012 21:18:24 GMT

Sorry, just been reading other dicussions and the -(Hyphen) I see represents Null or values with 0

Does this help with the request

I can't add a sample file - sorry

Mon, 29 Oct 2012 21:21:58 GMT

You can suppress the null values. In Chart Properties > Dimensions > Select 'Suppress when value is null':

Mon, 29 Oct 2012 22:19:26 GMT

Hi yes I have been using this for the charts I have created, however how could I do this with a text object where there is not Supress option.

This is why I'm trying to find a solution in the expresion I'm using.

Thanks for your continued support.

Rob

MayilVahanan — Mon, 29 Oct 2012 22:23:59 GMT

Try like this

=Alt(Sum(Sales),0)

If there is no values in sum(sales), i.e. null value( hypen) means, it display zero..

Edit:

want to Display blank means,use

Alt(Sum(Sales),'')

Regards,

R.MayilVahanan

Mon, 29 Oct 2012 22:34:06 GMT

Hi I have continue to play with the expresion and have the answer.

=FirstSortedValue(Response_Level_2, -aggr(sum({$<Question_List_ID={4},Response_Level_2-={'-'}>}Ans_Minutes),Response_Level_2))

By adding -={'-'} to the expression it has given te rsult I needed

Thanks for all of your suggestions.

Rob