5 Replies Latest reply: Oct 15, 2012 2:23 PM by John Witherspoon RSS

    no relation betwwen dimension and fact but how will i join it

    anutosh_dhar anutosh_dhar

      I have a dimension table .it has just 3 rows and single column like 2012,2011,

      Last 12 Months(for last 12 mm - last12mm meanings 2012sep to 2011oct).

       

       

       

      i have detail table which contains columns like

      cy_jan,cy_feb....cy_sep,cy_total(cy all total)

      ly_jan-ly_dec,ly_total(ly all total)   etc........

       

       

       

      i want to know

       

       

       

      if anybody click on 2012 it will display list of columns cy_jan---to -cy_sep

       

                                            click on 2011 it will display ly_jan-------to--ly_dec(in respect of 2011)

       

                                            click on Last 12 Months it will display cy_sep-------to--ly_oct

       

       

       

      is it possible in qlikview?

       

      please find the attached file which contains sample data.

      i have posted it earlier but did not get any response.

      please let me know whether it is possible using qlik view.