Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
mharm
Not applicable

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

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!

11 Replies
mharm
Not applicable

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

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
Not applicable

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

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

Measure: Parttime v Fulltime (measure one)

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

mharm
Not applicable

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

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

rupamjyotidas
Not applicable

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

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

mharm
Not applicable

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

qlickimageforum.png

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
Not applicable

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

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.

mharm
Not applicable

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

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??qlikform2.png

guruprem
Not applicable

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

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

mharm
Not applicable

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

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.