Forum Discussion

mmbaroja's avatar
mmbaroja
Frequent Visitor
4 years ago

Aggregation on rows with user selected filters

Hello: I am trying to recreate an analysis done previously with QlikView: A sales offer includes five types of offer (depending on the team who worked on the offer), many features and a few version...
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

If you only have five types you can select two from, there are only 10 possible pairs to pick from, so pre-calculating all of them doesn't necessarily seem impossible but, ideally, there are better options.

 

Are columns D:E calculated somehow or are the values already determined a priori?

 

It would help greatly if you could include some sample starting data you've got before you start trying to group and concatenate.

  • mmbaroja's avatar
    mmbaroja
    Frequent Visitor
    4 years ago

    You are right; impossible is not the best word. 🙂

    I would say not desirable at all. I see this as a generic problem so I could have 100 types and then it wouldn't be an option.

     

    Columns D:E are determined a priori. I just uploaded a sample data:

    https://lksscoop-my.sharepoint.com/:x:/g/personal/m_baroja_lksscoop_onmicrosoft_com/ETEzg7DzztVOvPY4SkGEOvQByQ2qLojrv2Q9CEVqQNe7_g?e=QJChM0

    There are over 100 features for an offer but i just included 9 of them (columns D:L).

     

    Thanks,

     

    MM.

    • AlexisOlson's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      4 years ago

      Can you share what rows and columns would correspond to your initial example? I'm having trouble matching up this spreadsheet with that example.

      • mmbaroja's avatar
        mmbaroja
        Frequent Visitor
        4 years ago

        Sure!!

        Find below an image with a simple example. One offer, one feature (just T_Max) and two type of offer: INC (user selected it as type offer1) and INP (user selected it as type offer 2).

        Left side is the spreadsheet and right side is the initial example (what the report should show): 

         

        So the mapping from the spreadsheet I uploaded would be:

        A: Num_Offer is column Offer of initial example

        B: Version. After applying concatenatex this is Revisions of initial example. 

        C: Offer Type. This is the type of offer and it is used to know where to put values of features  columns D and E of spreadsheet.

        D-L: This is are a few features of the offer.  The name of the feature is the value of column B of the initial example. Values from D-L (spreadsheet) are taken into columns D-E (initial example) based on the offer type selected by the user as the image above shows.