Script Optimization using without where condition

[BI_Rockstar_265]

Hi Folks,

I want to know the alternative and best optimized  functions instead of where condition in the backend script of qliksense.

[JuanGerardo]

Hi @BI_Rockstar_265 , you can use Join and Keep functions instead, usually with better performance than  Where condition. More info here: Combine tables with join and keep 

JG

[BI_Rockstar_265]

Hi, I dont want to use joins and keep function (is there any alternatives other than joins and keep)

[JuanGerardo]

Hi, I am curious about why you don't want to use where, join nor keep. Could you explain?

[MayilVahanan]

Hi

Based on the scenario, where condition / join / keep helps to optimize the script.

If ur question is general, yes, alternative for where condition is join / keep  alone.