topic Re: issue on if condition in QlikView

issue on if condition

Wed, 25 Nov 2020 16:16:04 GMT

Dimension : Type

i have expression like below:

if(BU=' ROLL',(Count({<Type={'App'},DEPT_L3={'Tech Solutions'},

DEPT={' Services',' Information Solutions','Workflow Solutions','Connected Care & Analytics',

'MHS','MTS Services'}, LC_STAGE={'Concept-Opportunity''},STATE={'Active'},WORK={'Application'}>}LC_STAGE)),

if(BU='ROLL',(Count({<Type={'Infrarad'},DEPT={'MTS '},

DEPT={'Services',' Information Solutions','Workflow Solutions','Connected Care & Analytics',

'MHS','MTS Services'},

LC_STAGE={'Concept-Opportunity'},STATE={'Active'},

WORK={'DCT','Recovery'}>}LC_STAGE)),

when i am applying this expression tp the chart i am getting only one if condition values i.e Type={'App'} but i am not getting Type={'Infrarad'} these vaules could u please help me out

Note : I need to show both Values i.e Type={'Infrarad'},Type={'App'}

Re: issue on if condition

sunny_talwar — Mon, 08 Aug 2016 22:05:51 GMT

How about this:

If(BU=' ROLL',

RangeSum(Count({<Type = {'App'}, DEPT_L3 = {'Tech Solutions'}, DEPT = {' Services', 'Information Solutions', 'Workflow Solutions', 'Connected Care & Analytics', 'MHS', 'MTS Services'}, LC_STAGE = {'Concept-Opportunity'}, STATE={'Active'}, WORK = {'Application'}>} LC_STAGE),

Count({<Type={'Infrarad'}, DEPT={'MTS '}, DEPT={'Services',' Information Solutions','Workflow Solutions','Connected Care & Analytics','MHS', 'MTS Services'}, LC_STAGE={'Concept-Opportunity'}, STATE={'Active'}, WORK = {'DCT','Recovery'}>} LC_STAGE))

Re: issue on if condition

Mon, 08 Aug 2016 22:20:06 GMT

Thanks sunny

Re: issue on if condition

sunny_talwar — Mon, 08 Aug 2016 22:20:17 GMT

No problem at all

Re: issue on if condition

Tue, 09 Aug 2016 14:43:32 GMT

hi sunny

That scenario works out properly but here one more scenario which i am trying to do implement but i am not getting exact results could you please help me on this

My Expression:

if(BU='MTS ROLLUP',

Rangesum(Count({<Type={'App'},DEPT={'MT Solutions)'}, DEPT={'Performance Services','Information Solutions','Imaging,' Analytics',

'Shared Services'}, LC_STAGE={'Test-Deploy'}, STATE={'Active'}, TIME={'Y'},TYPE={'Appl'}>} TIME)/

Count({<Type1b={'App'},DEPT={'MTS (McK Tech Solutions)'}, DEPT_L4={'Performance Services','Information Solutions','Imaging','Connected Care & Analytics','MD'},LC_STAGE={'Test-Deploy'},STATE={'Active'},TIME={'Y', 'N'}, WORK_TYPE={'Application'}>} TIME) * 100,

Rangesum(Count({<Type={'App'},DEPT={'MT Solutions)'}, DEPT={'Performance Services','Information Solutions','Imaging,' Analytics',

'Shared Services'}, LC_STAGE={'Test-Deploy'}, STATE={'Active'}, TIME={'Y'},TYPE={'Appl'}>} TIME)/

WORK_TYPE={'DPT','Recovery & Infrastructure','Infrastructure','ISRM & Infrastructure','Merger & Acquisition}>} TIME) * 100,

Thanks

Re: issue on if condition

sunny_talwar — Tue, 09 Aug 2016 14:45:53 GMT

What are you getting and what do you want to get? Can you share a sample because just by looking at the expression, it might not be straight forward as to what might be missing

Re: issue on if condition

Tue, 09 Aug 2016 14:57:35 GMT

If(BU=' ROLL',

By using this expression i got count but now i need to display the Percentage how to implement this scenario on the same expression

Re: issue on if condition

sunny_talwar — Tue, 09 Aug 2016 14:59:31 GMT

Percentage based on what? Based on a single dimension, multiple dimension? Yet again I feel we need more information before we can provide a working solution

Re: issue on if condition

Tue, 09 Aug 2016 15:08:17 GMT

Calculated dimesion: month &'-' &Type

Dimension values like AUG &'-'& APP like This

Re: issue on if condition

Tue, 09 Aug 2016 15:08:34 GMT

Single dimension Only

Re: issue on if condition

sunny_talwar — Tue, 09 Aug 2016 15:11:55 GMT

Not 100% sure, but may be this:

If(BU=' ROLL',

RangeSum(Count(TOTAL {<Type = {'App'}, DEPT_L3 = {'Tech Solutions'}, DEPT = {' Services', 'Information Solutions', 'Workflow Solutions', 'Connected Care & Analytics', 'MHS', 'MTS Services'}, LC_STAGE = {'Concept-Opportunity'}, STATE={'Active'}, WORK = {'Application'}>} LC_STAGE),

Count(TOTAL {<Type={'Infrarad'}, DEPT={'MTS '}, DEPT={'Services',' Information Solutions','Workflow Solutions','Connected Care & Analytics','MHS', 'MTS Services'}, LC_STAGE={'Concept-Opportunity'}, STATE={'Active'}, WORK = {'DCT','Recovery'}>} LC_STAGE)

)

Re: issue on if condition

Tue, 09 Aug 2016 20:03:22 GMT

Hi sunny

i am sharing sample document .please go through it and find the percentage of both the values in chart .

Thanks

Re: issue on if condition

sunny_talwar — Tue, 09 Aug 2016 20:07:07 GMT

What is the expectation here? the bars should add up to 100%?

Re: issue on if condition

Tue, 09 Aug 2016 20:17:26 GMT

Hi sunny,

Attached is the sample image for previous months we need like this

Re: issue on if condition

sunny_talwar — Tue, 09 Aug 2016 20:29:19 GMT

Is this what is required?

Re: issue on if condition

Tue, 09 Aug 2016 21:23:36 GMT

Yup, that is what we required but here is the issue, We have multiple if conditions in our expression, when we are using the expression what you provided is working fine individually. But the same expression we are using with other if conditions its not working properly..For more detail please see the output in attached image which we are getting.

Re: issue on if condition

sunny_talwar — Tue, 09 Aug 2016 22:47:57 GMT

Difficult to know what you need exactly. I really want to help, but I feel I am not fully aware about your data

Re: issue on if condition

Tue, 09 Aug 2016 23:26:27 GMT

Hi Sunny First of all thanks for your support

I am providing another sample qvw file in that we have multiple conditions.

If I am using individually that was working fine but when we are using with multip[le conditions its not working

For clear idea see attached qvw file

Re: issue on if condition

sunny_talwar — Tue, 09 Aug 2016 23:35:26 GMT

I think it would be helpful to know what the numbers need to be.

Re: issue on if condition

Tue, 09 Aug 2016 23:39:35 GMT

I am getting correct values for BPS and Canada. I need to get correct values for MTS ROLLUP and the values which you got previously is correct I need to get those values now in mts rollup

Thanks