Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SUPPOSE IN MY PROJECT I HAVE 3 FACT TABLES . TH FACT TABLES JOIN INTO ONE FACT TABLE.SO WHICH ONE IS THE BEST ONE? IN QLIKVIEW IS THEIR ANY METHOD TO JOIN FACT TABLES OTHER THAN "JOIN" CONCEPTS?...
Join the two fact table in qlikview we uses the Link tables method and link two fact tables to each other.
Yeah... Subbu; you can concate or you can user ApplyMap or Different joins (Left, right, inner, left keep, right keep); But still it all depend on the structure of your fact tables as well as the flow of data.
Find the attached image for reference. . .