Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

farisahamad
Contributor

Union of temporary tables in qlik

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.