Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm new to Qlik but familiar with other applications that are similar. I have a visual that I would like to create but not sure how to do it with Qlik. I've attached a PNG example with made up fields and data for illustration purposes. Anything that could be shared that can result in a similar visual would be great. There will be multiple items that I want to group on (i.e., as shown Items 1, 2, 3, etc.) and then there are sub-times (called Gates here) within that same item. A few different things can occur at each gate that includes Actions, Findings, Tasks, and Area. I would want each of these, if found within the gate to be displayed based on the date that they are found as an icon. Next to the icon, I would want to display a description.
I hope this is clear.
Thanks!
Neil
I can get the below - depending on your data you could replicate the below.
The formula for the Actions column is:
concat(
pick(Match(Gate,'INSP','REP','RECP','INST'),repeat(chr(160),0),repeat(chr(160),10),repeat(chr(160),20),repeat(chr(160),30))&
pick(Match(ResultType,'Area','Task','Finding','Action'),'📌','📥','🔎','🎬')
&' '&ResultDescription,Chr(10))
Just ensure that your sorting is :
1 : Item
2: Gate - by expression : =Match(Gate,'INSP','REP','RECP','INST')