Qlikview calculated dimension

Saranya1 — Sat, 16 Nov 2024 17:53:27 GMT

How can we interpret below set analysis to add to pie chart calculated dimension as a if condition?

How can we use P() Function in pie chart for calculating?

count({<Quote_Status = {'Lost'},Flag={1},Product=P({<Division={'A&H'}>}Product)*P({<Division={'P&C'}>}Product)>}[Quote Number])+
((count({<Quote_Status = {'Quoted'},Flag={1},Product=P({<Division={'A&H'}>}Product)*P({<Division={'P&C'}>}Product),
QuoteDateDifference={">30"}>-<Quote_Status = {'Lost','Bound'}>}[Quote Number])))

Re: Qlikview calculated dimension

Kushal_Chawda — Mon, 02 Nov 2020 12:53:16 GMT

@Saranya1 may be below

=aggr(if(count({<Quote_Status = {'Lost'},Flag={1},Product=P({<Division={'A&H'}>}Product)*P({<Division={'P&C'}>}Product)>}[Quote Number])+
((count({<Quote_Status = {'Quoted'},Flag={1},Product=P({<Division={'A&H'}>}Product)*P({<Division={'P&C'}>}Product),
QuoteDateDifference={">30"}>-<Quote_Status = {'Lost','Bound'}>}[Quote Number])))>0,Diemension),Dimension)

topic Qlikview calculated dimension in QlikView

Qlikview calculated dimension

Re: Qlikview calculated dimension