Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Saranya1
Partner - Contributor
Partner - Contributor

Qlikview calculated dimension

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])))

 

Labels (2)
1 Reply
Kushal_Chawda

@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)