Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hello everybody. I use the Vis.js timeline to visualize my projects. This is not a problem as long as the database looks like this:
This is displayed clean (with the necessary around it). One project per line with different milestones.
But I would like to have the data recorded as follows:
I had only thought to convert the Excel with MTrans or whatever. But I am not enough expert for that. I hope you can help me.
The solution can be the The Generic Load, or:
The next will be just pseudo code:
autonumber(projekt&meilenstein) as rnk
if(rnk=1,meilenstein,null) as meilenstein1,
if(rnk=2,meilenstein,null) as meilenstein2,
if(rnk=3,meilenstein,null) as meilenstein3
max(meilenstein1) as meilenstein1,
max(meilenstein2) as meilenstein2,
max(meilenstein3) as meilenstein3,
drop table stg1;
drop table stg2;
It works only when you have maximum 3 milestone (ofcourse, you can add extra fields, but it is not so convenient).
Hope this helps.
Thanks alot for the tip with "Cross Table". This is exactly what I need. And it is easy to use.