while loop in expression or help for multi-dimensional combo chart

[Anonymous]

can I put a while or a for loop into an expression?

I'm trying to make a multi-dimensional combo chart (qlik unfortunately doesn't seem to support it).  I'm trying to trick it then do conditional formatting.

for (i = 0; endIterator = 2; i + 1)

If( i = 1, Count(distinct {$

<BINFlagMonth={1}>} {$<[Emp Type]={'P'}>

}
BIN), Count(distinct {$

<BINFlagMonth={1}>} {$<[Emp Type]={'F'}>

}
BIN)
)

My main dimension is month, and I have 2 measures that I'm displaying,  so by month, I'm trying to display total positions available for Parttime v Fulltime (measure one) and the actual staffed parttime v fulltime positions (measure two).. making 2 distinct bars per month and two sub categories within each.

can i do this?  please say that it's possible!

[Anonymous]

Every chart that i need to make needs to display this type of view...  I'm not just showing part-time v full-time..  I'm showing departments and regions and etc..  so i need a viable solution

[rupamjyotidas]

Maybe add in Dimension Month and [Emp Type] Field.

Measure: Parttime v Fulltime (measure one)

Measure: Actual staffed parttime v fulltime positions (measure two)

[Anonymous]

you can have only 1 dimension on a combo chart i believe..  unless there's some way to trick it?

[rupamjyotidas]

Ughhh Qliksense..Can you share some of the data in excel.

[Anonymous]

This looks terrible.  please help me create the chart that i need!  or help me think outside the box to find a better solution..

[guruprem]

I guess you can split your problem into some ones 1) Do you need out of box Visualization? Turn to Qlik branch

2) Do you want a single chart to be responded by values with in dimension , Qlik by default do this, when you select.

[Anonymous]

i want the big blue bar to be replaced with the E/S Officer, E/S Enlisted, and E/S Other stacked on top of each other, and i want the ugly green color to be replaced with the onboard officer, onboard enlisted, and onboard not specified.  i don't want to have to click to see it all.  i want to see it all at once without having to click or drill down..  is that possible??

[guruprem]

In two different Stacked Bart charts one with E/S measures other with Onboard measures.

[Anonymous]

yes, two stacked bars side by side...one showing E/S slices/stacked and one showing onboard slices/stacked.  is this possible?

again, all of my charts need to look like this...so i need to find a viable solution.