Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have 2 dimension one is Comapny and the other is calculated dimension and I am using the below expression for calculated dimension in pivot table
IF(match(Company,'ABC'),[Invoice Date_FKDAT],Date(AppDate,'DD/MM/YYYY'))
but it shows allocated memory exceeded but this is working fine in straight table but as per my requirement I have to use Pivot table because i want my calculated dimension in horizontal orientation. Please help anyone.
@Kushal_Chawda @sunny_talwar Please have a look
Can you create this calculated dimension in script and use that field in chart ? Did you tried that ?
I can't because invoice date and App date are fields of two different tables and when i tried to create relationship it gives me loop error because sales table is already related to some other table using a field.
@sadiaasghar try below
aggr(IF(match(Company,'ABC'),[Invoice Date_FKDAT],Date(AppDate,'DD/MM/YYYY')),Company,[Invoice Date_FKDAT],AppDate)
here in below thread i have seen solution like...
create a new pivot table and recreate all your dimension and measures - did you tried this?
How are this 2 tables related ? is their 1:1 match or 1:many
If it has 1:Many and 2 tables are not linked directly then definitely this issue will occur . In Pivot the Dimension values gets aggr to each dimension value .
Could you create a sample app and share with us ?
I would venture Set Analysis the most likely way to go regarding the last part:
https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
Sorry I do not have anything better.
Regards,
Brett