5 Replies Latest reply: Aug 4, 2011 9:17 PM by bharadwaj pavuluri RSS

    Set analysis help

      Hello Qlikperts

       

      I need a small help regarding set analysis ....

       

      I have 15 colomns from various dimensions in my app & out of those 15 I want manipulate my selections from 5 colomns & i want to ignore other selections from the remaining 10 colomns .

      In a breif let us assume that i have 3 dimensions like

      Dim 1 :                            Dim2:                                Dim3:

      colomn1                         colomn6                             colomn9

      colomn2                         colomn7                             colomn10

      colomn3                         colomn8                             colomn11

      colomn4                                                                  colomn12

      colomn5                                                                  colomn13

                                                                                    colomn14

                                                                                    colomn15

       

       

       

      and i want to make selections modify my chart values from colomn1,colomn3,colomn7,colomn11,colomn15 and i want to neglect / ignore the impact of other colomns selection on my chart so

      In my set analysis i tried to write including these colomns like

       

      sum({1<colomn1=,....,colomn15=>}(sales/gross_sales))

       

      but it's not working & i tried in other way like hard coded one

       

      sum({<colomns i want to ignore>sales/gross)

       

      but this one is also not giving me my required valuations , Is there any thing i'm going wrong on it or else can anyone help me with ignoring those in a set analysis

       

       

       

       

       

      Thanking u all

       

      Meher