0 Replies Latest reply: Aug 1, 2016 11:59 AM by RAHUL SAXENA RSS

    Getting insights from sales data: Qlikview Sense

    RAHUL SAXENA

      Hi,

       

      I am new to Qlikview Sense. Can someone guide me on how to write queries/ logic to get insights like below, I am attaching a sample format of my data.

       

        1. Productive Store

                       a) P1M (Past 1 month)

                       b) P3M (Past 3 months)

                       c) P12M

                       d) how to compare vs previous month (OR this year current month vs last year same month)

        2. Brand Distribution - Brand billed in how many stores

                       a) P1M

                       b) P3M

                       c) P12M

                       d) how to compare vs previous month

        3. SKU Distribution

                       a) P1M

                       b) P3M

                       c) P12M

                       d) how to compare vs previous month

        4. Avg Purchase Qty of SKU

                       a) P1M

                       b) P3M

                       c) P12M

                       d) how to compare vs previous month

        5. Comparison in bar charts

                      a) this year vs last year same period

                      b) month vs target

                      c) H1 vs target

                      d) year vs target 

                      d) how to compare vs previous month