Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Removing - (Hyphen) results with in a Text Object

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

1 Solution

Accepted Solutions
Not applicable

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

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

6 Replies
Not applicable

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

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

Not applicable

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

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

Not applicable

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

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

Capture.JPG

Not applicable

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

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

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

Hi

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

Not applicable

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

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