Discussion board where members can get started with Qlik Sense.
I am trying to create calculated column Count based on two columns coming from join of two qvds.
something like :
Load * from qvd1
Load * from qvd2
Load* , if( booleanid='false',count,0) as CountTotal
Hi J ,
This looks correct , the resident load is the correct way to do this .. isnt this working ? what issue are you getting ?
It is taking a lot of time in loading data around 10 minutes.
You may speed up your task if you don't load all fields with a * wildcard and maybe only relevant records (means applying of any possible filters).
I assume that you only need one field from one of the tables to perform your calculation and in this case a mapping table would be more suitable, like:
m: load KEY, LookupValue from qvd_X (qvd) where exists(KEY);
t: load *, applymap('m', KEY, 'default') as New from qvd_Y;
Usually it's much faster as join approaches.
Thanks for your response. I am using only required fields in place of *.
Let me try out using mapping load.