Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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)

0 Replies