topic Re: Set analysis not working in QlikView

Set analysis not working

rittermd — Thu, 26 Feb 2015 20:49:34 GMT

If have a listbox called Program Type. It contains 5 values.

I have added [Program Type]= to my expressions so that they will not be affected by this listbox. This works for 4 of the 5 values. The expressions continue to change for the 5th value.

I made this change in about 6 expressions. They all do the same thing. Four of them do not change the expression and the fifth one does.

None of them should change the expression.

I am totally stumped.

Re: Set analysis not working

Anonymous — Thu, 26 Feb 2015 20:51:21 GMT

you are right that is weird....a sample app could help look into it a little further

Re: Set analysis not working

Anonymous — Fri, 27 Feb 2015 06:17:17 GMT

check whether the 5th value is repeated some where else or having connection with ur expression ....

Re: Set analysis not working

Fri, 27 Feb 2015 06:39:34 GMT

How did u write the expression for your Condition....Get me the SnapShot of your condition and the list box...

Re: Set analysis not working

CELAMBARASAN — Fri, 27 Feb 2015 06:50:39 GMT

Whats your expression?

If you have two parts in a expression like

Count({< [Program Type]=>} Programs) / Count(Total Programs), there is a posibility for that

It needs to used in both the parts like Count({< [Program Type]=>} Programs) / Count({< [Program Type]=>} Total Programs)

Thanks

Re: Set analysis not working

jyothish8807 — Fri, 27 Feb 2015 06:56:18 GMT

Hi Mark,

Can you share your expression. it will help us to understand more.

Regards

Re: Set analysis not working

rittermd — Fri, 27 Feb 2015 14:15:24 GMT

Here is one of the expressions that I changed: (eIdentifiedPatients)

Count({$<[Program Type]= ,GICMembMaxProgression={'RY'}+{'RN'}+{'EN'}+{'SN'}+{'MY'}+{'MN'},[Reporting Period] = {'<=$(=Date(vMaxPeriod))'}>}DISTINCT MIGICMembID)

I added Program Type to the existing expression. It works for 4 of the 5 values that Program Type has.

The above expression is used in a text object to display the values on the dashboard. Can I use the Set Analysis in that expression instead of in the components that make it up?

Here is that expression:

= Num($(eIdentifiedPatients),'#,##0') & ' / ' & Num($(eIdentifiedPatients) / $(eInsuredPopulation),'#0.0%')

Re: Set analysis not working

rittermd — Fri, 27 Feb 2015 14:24:36 GMT

I just posted it. Thanks

Re: Set analysis not working

rittermd — Fri, 27 Feb 2015 17:03:24 GMT

Problem solved. The Set Analysis was working fine. The problem was with some other code in the expression that affected this one Program Type differently than the others. We removed that code and everything is working just as it should.