topic Analysis need to set example (Necesito ejemplo de set analysis) in QlikView

Analysis need to set example (Necesito ejemplo de set analysis)

Wed, 15 Jul 2015 04:47:29 GMT

i am new and wanted an example of product sales for years, applying September analysis

if they were so kind to explain one or compatir me a basic example would be great

I enclose my table waiting for one explain me an example.

Translated with Google Translate - Qlik Community Administrative Team

hola soy nuevo y quisiera un ejemplo de ventas de productos por años, aplicando set analisys

si fueran tan amables de explicarme uno o compatir un ejemplo basico conmigo seria genial

adjuntare mi tabla esperando que alguno me explique un ejemplo.

Re: Analysis need to set example (Necesito ejemplo de set analysis)

Anonymous — Wed, 15 Jul 2015 20:02:29 GMT

Hi,

I changed your excel file to make it better to explain, first of all, you need to create a star schema or snow flake, where you have a fact table in center and around it the dimension tables, you can find some explanation here:

Star Schema or Snow Flaxe schema?

About the set analysis, I made per year because that's the dimension you have. If you want per month you need to put the month in the excel file. Then change the set analysis.

Re: Analysis need to set example (Necesito ejemplo de set analysis)

Thu, 16 Jul 2015 07:48:35 GMT

gracias , thanyou