Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Resolve the Following Equation to knowledge dimension ()

I need to be able to resolve the following equation to know the dimension in the pivot table automatically.

I need to take out VehicleGroupName={'DimensionName'}>} and havr it automatically respect the dimension in the pivot table.

Count({<Inv={"=sum({<VehicleGroupName={'DimensionName'}>}aggr(exp(sum(log(1+Value1)))-1, VehicleGroupName,Inv))

  <  

(exp( SUM( TOTAL<VehicleGroupName, BusinessDate>  aggr(log(1+SUM({<VehicleGroupName={'DimensionName'}>}PValue2)

    /SUM({<VehicleGroupName={'DimensionName'}>}PValue3))

, VehicleGroupName, BusinessDate)))-1)"

}>} Distinct Inv)

Labels (1)
0 Replies