topic Re: counting expressions in QlikView

counting expressions

Thu, 20 Sep 2012 18:41:48 GMT

Hi i would like to be able to create a stack chart out of an expression column which shows values -1 and 0. (see screenshot)

-1 = red & 1 = green

is it possible to count these expressions to receive an amount for both values and represent them in a piechart?

the actual values represent SLA Level measurements if a a case has met the time requirements or not.

a picture reference is attached to this post.

//Best

Bradley

Re: counting expressions

whiteline — Sat, 22 Sep 2012 19:32:22 GMT

Hi.

Use set analysis:

=Count({<Visual={"-1"}>} Visual)

Re: counting expressions

Sun, 23 Sep 2012 14:10:10 GMT

Thanks for the reply.

i have tried with the code provided, however recieve the following message; Bad fieldname(s); Visual;

any tips;

Brad

Re: counting expressions

whiteline — Sun, 23 Sep 2012 15:56:29 GMT

Obviously, you should change the expression according to your field names.

I guess that Visual is a field name.

Re: counting expressions

Sun, 23 Sep 2012 15:58:34 GMT

Hi.

the expression name is Visual. but it carries no real pre-defined field name.

is it still possible to calculate values from an expression?

Re: counting expressions

Sun, 23 Sep 2012 15:59:49 GMT

Thank you for your reply.

The expression is named Visual.

Is it possible to still count values if the data is derived from an expression and not a true field name?

Re: counting expressions

whiteline — Sun, 23 Sep 2012 16:08:50 GMT

It's possible. But you have to use some dimension to perform such selection (as if it's done manually), for example:

=Count({<Dimension={"=(Your expression for Visual)=-1"}>} Dimension)

Re: counting expressions

Mon, 24 Sep 2012 03:19:28 GMT

Hi.

Thank you kindly once again.

I have tried to establish this logic into my application however, it seems to show error.

I was wondering If I attach my application to this mail, would it be possible for you to take a look at my dimension?

Your help would be greatly appreciated in this matter.

Best,

Brad

Re: counting expressions

whiteline — Mon, 24 Sep 2012 04:36:33 GMT

Ok, I see 😃

It's a bit monstrous, cause you have a rather complex expression:

=Count({<Ärende_ID={"=((NetWorkDays(Created,[Updated])- IF(Frac([Updated]) < Time#('17:00','hh:mm'),1,0)-IF(Frac([Updated]) > Time#('17:00','hh:mm'),1,0)- IF(Frac(Created) > Time#('08:00','hh:mm'),1,0) - IF(Frac(Created) < Time#('08:00','hh:mm'),1,0))*8+ RangeMax(((Time#('17:00','hh:mm') - Frac(Created))*24),0)+ RangeMax(((Frac([Updated]) - Time#('09:00','hh:mm'))*24),0)) > SLAend"}>} Ärende_ID)

I think you could consider to make some calculations in script to simplify it.

And just to get better understanding what it is doing (this one is not working but looks much easier):

=Count({<Ärende_ID={"=[Total Hours]>SLAend"}>} Ärende_ID)

Re: counting expressions

Mon, 24 Sep 2012 06:13:29 GMT

Thank you for your help. It came at a very needy time and now I understand how the logic should be applied to further applications.

You know Qlikview is extremely powerful once you understand the mechanics behind it all.

I am an avid SAP BW consultant but find myself more and more convinced of Qlikview.

Have a great week.

//Brad

Re: counting expressions

whiteline — Mon, 24 Sep 2012 06:52:05 GMT

You're welcome.

That's right, and sometimes the mechanics is not so obvious 😃

If it helps, please, close the question. Thx.