topic Re: Summarize values for a list box filter in QlikView

Summarize values for a list box filter

Tue, 11 Mar 2014 08:19:27 GMT

Hi,

I have a field in a table box that deals with percentage values, which can be anything from 0-100. In my filter listbox, I would like to summarize them:

0-19%

20-39%

40-59%

60-79%

80-100%

I solved this with this expression:

=if(OPPORTUNITY.OPPORTUNITY_PROBABILITY >= 0 and OPPORTUNITY.OPPORTUNITY_PROBABILITY < 20, ' 0 - 19%',if(OPPORTUNITY.OPPORTUNITY_PROBABILITY >=20 and OPPORTUNITY.OPPORTUNITY_PROBABILITY < 40, '20 - 39%', if(OPPORTUNITY.OPPORTUNITY_PROBABILITY <=40 and OPPORTUNITY.OPPORTUNITY_PROBABILITY < 60, '40 - 59%', if(OPPORTUNITY.OPPORTUNITY_PROBABILITY >=60 and OPPORTUNITY.OPPORTUNITY_PROBABILITY < 80, '60 - 79%', '80 - 100%'))))

Problem is, that when I select one of these regions, the Current selections box does not show e.g. '0-20%', but 10, 12, 19 as listed values. How can change this? And is there a better way to create the summary than using that ugly if-statement?

Thanks

Jens

Re: Summarize values for a list box filter

sudeepkm — Tue, 11 Mar 2014 08:31:00 GMT

You can keep this code in your load script and create a new field like OPP_PROB.

Please take a look at the example.

Re: Summarize values for a list box filter

MK_QSL — Tue, 11 Mar 2014 09:24:09 GMT

Try to use class function.

Please check enclose file...

Re: Summarize values for a list box filter

Tue, 11 Mar 2014 12:30:14 GMT

I already implemented the version from Sundeep, but I will check yours, too, for sure. Although I have to admit that I never worked with the Class function.