0 Replies Latest reply: Sep 26, 2017 8:14 AM by Faris Ahamad M RSS

    Union of temporary tables in qlik

    Faris Ahamad M

      dimensions and their calculations are as follows

       

      Create date  : if(cr=1 ,cr_date, dr_date)

      Expiry_date : if(exp=1,a_exp_date,b_exp_date)

      Completion Date :  work_completion date

       

      And I have 3 measures:

      count(document_id)

      count(if(cr=1,document_id))

      count(if(exp=1,document_id))


      I want to create combo bar chart where x axis is date .And it should be union of all these dates.I need to show these measures on the same chart.



      Please help me on this.