My percentage showing Correct when i don't click , when i click particular state its showing 100% not Right percentage i want show correct %

[Vijayqlik4171]

[hic · Accepted solution]

When you have selected one row only, the row is 100% of the total. So it is correct.

The question is rather: How do you define the total? Is it the total of the chart? Or is it the total of the app (without selections)?

Maybe you should try 

   Sum(Amount) / Sum({1} total Amount)

instead of

   Sum(Amount) / Sum(total Amount)

See more on the following blog posts:

https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990

https://community.qlik.com/t5/Qlik-Design-Blog/The-Aggregation-Scope/ba-p/1467321 

[AG-gugelbisolutions]

Well, this is a by design feature because, when you make a selection, you are narrowing down your analysis perimeter and, therefore, somewhat moving the concept of 100%.

However, if you really want to preserve the percentage in case of selections on [Ship-To State], you can try the following approach:

• define a new variable vNetAmountOutstanting_noShipTo with a set-analysis that makes the formula insensible to [Ship-To State] selections
  • something like =sum({$< [Ship-To State]= >} [Net Amount Outstanding] ) 
  • please note that you must start the variable definition with "="
• define the "% of Total" formula using vNetAmountOutstanting_noShipTo in the denominator

Hope it helps

[Vijayqlik4171]

thank you so much henric