topic script help in QlikView

script help

arusanah — Thu, 07 Jul 2016 01:29:41 GMT

This logic I have to implement in one of my sense SimpleKPI objects.

I am creating 3 calculated Dimensions using expression

If(([New Enrollment]='N' and Enrollment='Y' and Disenrollment='N'),'Enrollment') as [Enrollment],

if(([New Enrollment]='Y' and Enrollment='Y' and Disenrollment='N'),'New Enrollments') as [New Enrollment],

if(([New Enrollment]='N' and Enrollment='Y' and Disenrollment='Y'),'Disenrollments') as [Disenrollment]

My requirement is to make above said object acts as filter.

With above script ,What happens is when I click on one of the above mentioned dimensions my other two dimension label as well as value returns 0. Where as client wants to see default values in those dimensions. How can I modify my script ?

Re: script help

sunny_talwar — Thu, 07 Jul 2016 01:48:46 GMT

May be this:

If([New Enrollment]='Y', 'New Enrollments', If(Disenrollment='Y', 'Disenrollments', 'Enrollment')) as Status

Re: script help

arusanah — Thu, 07 Jul 2016 02:31:34 GMT

no Sunny it doesn't work already tried this option.

you can see commented portion . if I try this way I can see only one of the 3 objects at a time.

Re: script help

arusanah — Thu, 07 Jul 2016 02:33:43 GMT

I wont be having list boxes. I just have 3 simplekpi objects. which when user clicks should refresh entire dashboard

Re: script help

tamilarasu — Thu, 07 Jul 2016 02:34:48 GMT

I misunderstood the question. OP needs to change script. So, I have removed my comment. Feeling very sleepy in morning.

Re: script help

arusanah — Thu, 07 Jul 2016 02:40:36 GMT

no worries nagraj!!

Re: script help

tamilarasu — Thu, 07 Jul 2016 02:41:06 GMT

See attached file.

Re: script help

arusanah — Thu, 07 Jul 2016 02:50:53 GMT

this same what I have already done, it doesn't work.

Re: script help

tamilarasu — Thu, 07 Jul 2016 02:55:42 GMT

Arusanah,

Have a look at the new attachment.

Re: script help

sunny_talwar — Thu, 07 Jul 2016 03:02:06 GMT

I am not entirely sure as to what the requirement is. May be if what Tamil has provided doesn't work, then please expand a little on your requirement

Re: script help

arusanah — Thu, 07 Jul 2016 13:25:43 GMT

what myself , U & Tamil did was created a single dimension with values 'Enrollment','New Enrollment' &'Disenrollment' so when we click one object other two returns zero.

now my client wants that even if we click on one lets say enrollment . entire dashboard should be refreshed with enrollment data and the other two simple kpi objects ('New Enrollment' & 'disenrollment' should display there default value.

Re: script help

stualsford — Thu, 07 Jul 2016 13:44:41 GMT

It's possible I have missed the request entirely, however, I read it as you want the 3 text boxes from within your example to stay as their default value (10), even after you have changed the value of the 3 dimensions on the left.

I've done this using set analysis which hopefully does what you're after. The names on the boxes were changing as you were bringing in the field values rather than leaving the caption as text. I have changed that as well but I'm still not sure what you're after.

The current set will ignore ALL other selections. You may not want that. If you remove the one you can nullify the selections of the enrollment types by using

Enrollment:

=Count({$<Enrollment={'Enrollment'},Disenrollment=,[New Enrollment]=>} [Person ID])

New Enrollment:

=Count({$<[New Enrollment]={'New Enrollments'},Enrollment=,[New Enrollment]=>} [Person ID])

Disenrollment:

=Count({$<Disenrollment={'Disenrollments'},Enrollment=,[New Enrollment]=>} [Person ID])

These would allow all of the filters on the other sheet to apply.

(Edited to fix typing)

Re: script help

Anonymous — Thu, 07 Jul 2016 13:51:53 GMT

Arusanah were you able to resolve your issue.

Re: script help

arusanah — Thu, 07 Jul 2016 21:13:56 GMT

Thank You Stu . it worked for me .... Thank u so much !!!

Re: script help

simondachstr — Tue, 18 Sep 2018 11:17:34 GMT

Hey!

While you're at it, have a look at Vizlib's new supported KPI designer:

https://www.vizlib.com/kpi/‌

Keen to hear your thoughts!

Best,

Martin