Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

praveen1108
Contributor

Optimized Expression for given exp

Hello Friends,

Can someone please help me with the optimized expression for below.

It is taking lot of time to process due to which my dashboard performance is very slow.

Optimized Expression for below:

If(

   (Min({1}DEPTH)=Dimensionality() OR Dimensionality()=1)  //get rid of the unwanted null rows

    AND Count(RowNumber)>0,  //this is used to make the chart filter properly

  

   SubField(

      Concat({1}Quantity,',',DEPTH),  //Build comma delimited string of Partnumbers sorted by depth in hierarchy

            ',',1)  //Subfield to only return the first partnumber from the comma-delimited string

           )

Regards,

Praveen

1 Reply

Re: Optimized Expression for given exp

I don't know sense well but I think you could your subfield-expression already create within the script and believe you didn't need those conditions to get rid of NULL.

- Marcus

Community Browser