How to create Product Value Brackets (dynamically based any selection)

[#1]

Hi All

Just need your extended support for one of our client reuiqrement.

We pasted (Hardcoded) our reuirement in the .qvw .

What we need here is how to bring a Bracket into List box or user defined field. or calculated dimension.

We need to calculate dynamically based on period as well as other selections.

Thanks in advance .

Bhushan N

[#2]

Hi,

hope this example helps.

Good luck!

Rainer

[#3]

Hi Rainer

What you have done is based on revenue .

We need to explore more to find our requirement . We requred here is " My top 20% cusotmers (Revenue wise ) contributing how much % of my total revenue " instead of "Which customers contributing "%" of my revenue "

I hope you can definitely provide me some links.

Thanks for quick suggestion.

Bhushan N

,

With which customers do I make '

& Num(A,'0%') &

' of my turnover?'

[#4 · Accepted solution]

Hi,

maybe the "Pareto" function could help:

Add Action Dialog (Create a Button=> Properties => Actions => Add => Select => Pareto Select)

Pareto Select

Makes a pareto selection in the specified field based on an expression and percentage. This type of selection is used to select the top contributors to a measure, typically in line of a general 80/20 rule. For example, to find the top customers that contribute to 80% of the turnover, Customer should be used as field, sum(Turnover) should be used as expression and 0.8 should be used as percentage.

Rainer

[#5]

Hi Rainer,

Thanks alot for your advice, we will try on this & hoping we will get our desired results.

Rainer , can you please provide us any clues on how we can able to do "Sub reports " which we mentioned in below link in Forum .

http://community.qlik.com/forums/t/23815.aspx

Bhushan N