Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
praveen1108
Creator
Creator

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
marcus_sommer

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