topic List Box Help in QlikView

List Box Help

Thu, 31 Mar 2011 12:41:17 GMT

Hi Qlikviewers

Could somebody help explain to my why this list box on the attached file doesnt work??

Many Thanks
James

List Box Help

rbecher — Thu, 31 Mar 2011 12:57:07 GMT

Hi James,

you would need to aggregate, maybe this expression will help for the listbox:

=if(aggr(sum(Incurred), [Claim Number], [Claimant Type])=0,'C','O')

- Ralf

List Box Help

Thu, 31 Mar 2011 13:10:18 GMT

Hi Ralf,

Just for clarification,

When the if statement

=if(sum(Incurred)=0,'C','O') is used in the dimension. it is throwing the error and when used in the List Box Virtually it is not showing the data. But when used as expression it is working fine without using an aggreagtion. How does it works internally.

List Box Help

rbecher — Thu, 31 Mar 2011 13:16:45 GMT

I don't get your question. This expression is working in the Listbox expression. I've tried this on QV 10.

- Ralf

List Box Help

Thu, 31 Mar 2011 13:25:53 GMT

Hi Ralf,

I am using Qv9.

Consider the James QVW file itself,

=if(sum(Incurred)=0,'C','O') is used an expression and data was displaying.

And the same is used as

=if(sum(Incurred)=0,'C','O') in the list box it was not working. But your solution was working.I mean after adding the aggregation.

And just tried to used =if(sum(Incurred)=0,'C','O') as Dimension it was throwing error. So what is the role of Aggr in this expression.

Why the same statement works in the expression but not in Dimesion and the List box without adding aggr. After adding aggr it is working.why?

List Box Help

rbecher — Thu, 31 Mar 2011 13:41:08 GMT

XXX,

1. How QV can sum without a dimension (in a listbox)? How should it know which dimension to use?

2. You will understand this if you add a 'current selection' box. There you can see what selection QV is making if you click 'O' on the listbox. It selects the associated dimensions.

- Ralf

List Box Help

Thu, 31 Mar 2011 13:46:40 GMT

Thanks for your help Ralph

I think i need to play with the aggregation,as i have way more fields in my original cloud solution, i will give you a shout if i get stuck

Much Appreciated, James

List Box Help

Thu, 31 Mar 2011 14:54:07 GMT

Hi Ralf

I can't seem to get it to work. the list box doesn't return the correct fields.

could you have a look at this please??

i have tried myself but am having trouble... I'm still getting used to this front end stuff.... my skills lie in the SQL part still !!

Thanks again

List Box Help

Thu, 31 Mar 2011 15:32:10 GMT

Hello I have this

if(sum(Incurred)>1,'C','O')

Try that for your ListBox Expression... It looks like it worked something, but not sure if thats what you want.

ANDY

List Box Help

rbecher — Thu, 31 Mar 2011 20:43:58 GMT

James,

I see, this is not working with with a two dimensional aggregation. I think it could work if you would have both dimensions concatenated in one field:

[Claim Number] &[Claimant Type] as Dim

But a better solution could be an aggregation table with sum(Incurred) if you need this as selection.

- Ralf

Re: List Box Help

simondachstr — Sun, 16 Feb 2014 22:35:17 GMT

I would recommend to you creating a new aggregated field in the script using ApplyMaps e.g. to properly flag the records.

Re: List Box Help

Mon, 17 Feb 2014 00:49:49 GMT

Hi Neil, Please try this.