Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Flags Tutorial

Hi all. I've been struggling with one requirement for about 2 months now and when I thought I had a solution, the data on the back end didn't look right. I've received pieces of helpful info from a few people but I haven't been able to pull it all together and I am about to give up.

I tried using a post regarding flags but it didn't work for me. I think I need a better understanding of how to load the data first as I don't think simply adding '  1 as Flag ' works for me.

In my data, I have a an APP table with fields called ALLOC_HRS, ACT_HRS and TASK_ID.

I have a DM_TASK table with fields called TASK_ID and TASK_IS_PTO flag with a possible result of 'Y' or 'N'.

The requirement is to display a combo bar chart with FTE (full time equivalent) ALLOC_HRS in one bar compared to FTE ACT_HRS but the TASK_IS_PTO time need to be called out separately on the second bar. Also, the ALLOC bar should be before the ACT bar.

FTE is calculated by using the following denominator: sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR, FLAG_PTO))

  1. First, am I loading the Flag right or do I need to add something in my script? It doesn't apply to ALLOC_HRS but I am getting a null Flag for those values.
  2. What about the Flag as the Dimension?
  3. Why does the graph work with hours but not when I have the FTE denominator?
  4. How can I get Alloc to show before Actuals? (I tried to make the dimension alt(FLAG_IS_PTO,0) but that did not work.

Thank you all for any help.

Cassandra