topic Re: Straight table Total value issue in QlikView

Straight table Total value issue

mayankraoka — Mon, 08 Aug 2016 13:40:37 GMT

Hi All,

I have straight table having 2 dimensions and 1 metrics.I am showing the total value as well.I want the total value will be displayed only when all the rows have value if any table value is not there(NA),It should not show total value.

Attached Image.In this image whenever NA is there total should not be displayed.

Can anyone help me on this.

Regards,

Mayank

Re: Straight table Total value issue

trdandamudi — Mon, 08 Aug 2016 14:05:31 GMT

Please see the attached:

Re: Straight table Total value issue

mayankraoka — Tue, 09 Aug 2016 10:37:05 GMT

Thank you for your reply.

In my case attached Image2 for your reference.In this highlighted in red where if any one value is NA total should be NA But it is not.

Can you please tell me what all settings you did?I ahve just used pivot chart and used partial sum option.

Regards,

Mayank

Re: Straight table Total value issue

trdandamudi — Tue, 09 Aug 2016 12:50:44 GMT

There are no other settings:

Select partial sum option for Geo_State and use the below dimensions and expressions for the pivot chart:

Dimensions:

Geo_State

Expressions:

metric1:

Sum(metric1)

Market:

If(Len(Trim(Market))>0,Market,'NA')

If(Len(Trim(Share))>0,Share,'NA')

Re: Straight table Total value issue

mayankraoka — Tue, 09 Aug 2016 13:03:19 GMT

I did the same in my case it is not showing NA in total.I have some confidential condition if that passses then will show the value else will show NA.

Any input on this please?

Regards,

Mayank

Re: Straight table Total value issue

trdandamudi — Tue, 09 Aug 2016 13:10:53 GMT

Is it possible to upload a small sample to look at it ?

Re: Straight table Total value issue

settu_periasamy — Tue, 09 Aug 2016 14:10:11 GMT

what is your expression?

Re: Straight table Total value issue

mayankraoka — Tue, 09 Aug 2016 14:27:22 GMT

Please find attached sample application

Re: Straight table Total value issue

settu_periasamy — Tue, 09 Aug 2016 14:48:00 GMT

for expression 'Market', try this..

=aggr(
IF(CT='IND PHA',if(Count(DISTINCT CM)>2 and max(OTLT_CNT)>3,Sum( {<CM=>}sales),'NA'),
if(Count(DISTINCT CM)>2 and Count(DISTINCT ENTERPRISE)>1 and max(OTLT_CNT)>2,Sum( {<CM=>}sales),'NA')),ST_CD,BG)

Re: Straight table Total value issue

mayankraoka — Tue, 09 Aug 2016 14:56:32 GMT

Hi Sethu,

In this case I am not getting value where both the records have value.

Regards,

Mayank

Re: Straight table Total value issue

settu_periasamy — Tue, 09 Aug 2016 15:17:25 GMT

Can you this this one?

=if(Dimensionality() =0 or Dimensionality()=1,
if((Wildmatch(concat(distinct aggr(
IF(CT='IND PHA',if(Count(DISTINCT CM)>2 and max(OTLT_CNT)>3,Sum( {<CM=>}sales),'NA'),
if(Count(DISTINCT CM)>2 and Count(DISTINCT ENTERPRISE)>1 and max(OTLT_CNT)>2,Sum( {<CM=>}sales),'NA')),ST_CD,BG),'|'),'*NA*'))>0,'NA'),
IF(CT='IND PHA',if(Count(DISTINCT CM)>2 and max(OTLT_CNT)>3,Sum( {<CM=>}sales),'NA'),
if(Count(DISTINCT CM)>2 and Count(DISTINCT ENTERPRISE)>1 and max(OTLT_CNT)>2,Sum( {<CM=>}sales),'NA')))

Re: Straight table Total value issue

mayankraoka — Tue, 09 Aug 2016 17:39:51 GMT

Hi Sethu,

I tried this also,It is also not working.

Regards,

Mayank

Re: Straight table Total value issue

mayankraoka — Tue, 09 Aug 2016 18:50:15 GMT

Any help on this is highly appreciated?

Regards,

Mayank

Re: Straight table Total value issue

mayankraoka — Wed, 10 Aug 2016 13:02:51 GMT

Experts,

This is urgent requirement.Can anyone help me on this?

Regards,

Mayank

Re: Straight table Total value issue

mayankraoka — Thu, 11 Aug 2016 08:13:41 GMT

Hi All,

Thank you very much for your inputs .I got the solution for above question.

Regards,

Mayank