Discussion board where members can get started with Qlik Sense.
I already combined two table using join. But now i want to transform my data as below. Please help. Thanks.
a) Create new line item for each task with created status
b) Create new field "Month_Graph." & assign "Task Created" as its date.
Go to Solution.
When you use sum() or count(), you need to add group by!
.... as Total
group by Temp, month_created, [PSR No];
I almost done. But i cannot add this expression. Please advise. Thanks.
Do you have any advise? Thanks.
'created' as status,
task_created as month_graph
task_modified as month_graph
Thanks Fei Xu.