topic Input Field and Straight Chart in QlikView

Input Field and Straight Chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

HI All,

i have a straight chart.

Dimension -- Details_Drill : Region-Plan-Agent-Account-Location

EXpression -- Annual Loss Ratio : if(len(vInput=0, sum({<Y_Q={"$(=max(Y_Q))"}>}AnnualLoss) / sum({<Y_Q ={"$(=Max(Y_Q))"}>} Distinct PolicyPremium), if(((sum({<Y_Q = {"$(=max(Y_Q))"}>} AnnualLoss) / sum({<Y_Q ={"$(=Max(Y_Q))"}>} Distinct PolicyPremium))*100)>=(vInput), sum({<Y_Q={"$(=max(Y_Q))"}>}AnnualLoss) / sum({<Y_Q ={"$(=Max(Y_Q))"}>} Distinct PolicyPremium)))

now, when input any value say 10 then only those Region should reflect which has values greater than 10% rest having - should not b displayed. Also, when I select any Region, the chart should drill to Plan then to Agent so on.

if u c the image, aggregation is happening on Top level n as u Drill inside the values are coming correct.

‌

Re: Input Field and Straight Chart

sunny_talwar — Wed, 26 Oct 2016 15:57:01 GMT

I don't see any image here, did you forget to add one?

Re: Input Field and Straight Chart

Anonymous — Thu, 27 Oct 2016 07:16:42 GMT

‌i added don't know y it didn't get reflected. Anyway..

Re: Input Field and Straight Chart

sunny_talwar — Thu, 27 Oct 2016 19:52:48 GMT

I believe that you need to use Aggr() function to perform your if expression check.

If(Len(vInput=0, Sum({<Y_Q={"$(=max(Y_Q))"}>}AnnualLoss) / Sum({<Y_Q ={"$(=Max(Y_Q))"}>} DISTINCT PolicyPremium),

Sum(Aggr(

If(((Sum({<Y_Q = {"$(=max(Y_Q))"}>} AnnualLoss)/Sum({<Y_Q ={"$(=Max(Y_Q))"}>} DISTINCT PolicyPremium))*100)>=(vInput), Sum({<Y_Q={"$(=max(Y_Q))"}>}AnnualLoss)

, Region, Plant, Agent, Account, Location))

/ Sum({<Y_Q ={"$(=Max(Y_Q))"}>} DISTINCT PolicyPremium)))