topic Re: convert snowflake schema into star schema in QlikView

convert snowflake schema into star schema

KundanJyothsna — Sat, 16 Nov 2024 19:37:38 GMT

Hi everyone,

Can anyone nuture me in converting application from snowflake schema into star schema along with some sample data using applymap?

Re: convert snowflake schema into star schema

anushree1 — Thu, 21 Nov 2019 05:55:38 GMT

You can convert the snowflake to star using the join between the tables involved in snowflake.

If you can share the sample app that you are working on, I can try and help you with the join.

For Apply map sample , please refer https://community.qlik.com/t5/QlikView-App-Development/quick-applymap-example/td-p/515616

Re: convert snowflake schema into star schema

KundanJyothsna — Thu, 21 Nov 2019 11:59:53 GMT

Thanks anushree for the answer. But I need to implement that using applymap instead of joins and moreover i don't have any sample app. I just needed the sample app from anyone of you.

I dont know how and where to start so as to implement it.

Thanks

Kundan

Re: convert snowflake schema into star schema

anushree1 — Fri, 22 Nov 2019 05:40:32 GMT

Apply Map sample explanation is on the URL I sent please check

Re: convert snowflake schema into star schema

Brett_Bleess — Wed, 04 Dec 2019 20:51:15 GMT

You can also check out the following Design Blog post, that may help as well:

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592

Regards,
Brett