topic Re: Avoiding blanks on pivot table in QlikView

Avoiding blanks on pivot table

NavinReddy — Wed, 06 Apr 2016 13:39:01 GMT

Hello Dear Experts,

i am trying to display the page only Tier1 values for three months for that i am using below expression

=only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}

if ((RAG_RATING_CD) = 'R', '1'))

Here im getting Tier1 including the blanks, i just want to remove the blanks

i need help on restrict the page to only Tier1 values any suggestion

for reference i have attached image

Thanks In Advance,

Niranjan

Re: Avoiding blanks on pivot table

sunny_talwar — Wed, 06 Apr 2016 13:41:37 GMT

I guess use an if statement for all your expressions except for [Tier Status] expression

=If(Len(Trim(Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))) > 0, Expression)

Re: Avoiding blanks on pivot table

NavinReddy — Wed, 06 Apr 2016 13:54:06 GMT

Hi Sunny,

Thanks for your reply

on expression column what you want me to write

=If(Len(Trim(Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))) > 0, Expression)

Re: Avoiding blanks on pivot table

sunny_talwar — Wed, 06 Apr 2016 14:00:38 GMT

I guess all remaning expressions. How many do you have in total?

Re: Avoiding blanks on pivot table

NavinReddy — Wed, 06 Apr 2016 14:04:58 GMT

its will change based on MonthYear selections

you mean to say like below mentioned

suggest me if im wrong

=If(Len(Trim(Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))) > 0,

only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if ((RAG_RATING_CD) = 'R', '1')))

Thanks,

Niranjan

Re: Avoiding blanks on pivot table

NavinReddy — Wed, 06 Apr 2016 14:10:38 GMT

=If(Len(Trim(Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))) > 0,

Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))

with above expression still im getting blanks

Thanks,

Niranjan

Re: Avoiding blanks on pivot table

Chanty4u — Wed, 06 Apr 2016 14:14:15 GMT

hi,

Load

if (Fieldname <> 0,FieldName) as Fieldname

Re: Avoiding blanks on pivot table

NavinReddy — Wed, 06 Apr 2016 14:18:53 GMT

Hi Chanty,

its not actually blanks

im trying to displaying only Tier1(pink) columns

Thanks,

Niranjan

Re: Avoiding blanks on pivot table

NavinReddy — Thu, 07 Apr 2016 04:26:29 GMT

Dear Experts, Any suggestion

Re: Avoiding blanks on pivot table

jonathandienst — Thu, 07 Apr 2016 04:58:58 GMT

You need to apply Sunny's suggestion to all the expressions. To suppress a row, all the expressions must evaluate to exactly zero, or null. If any do not, then the row will be displayed.

Re: Avoiding blanks on pivot table

settu_periasamy — Thu, 07 Apr 2016 05:01:26 GMT

Hi,

May be try this for all your expression (already sunindia‌ suggested) except which is showing value '1', i think middle expression

1st Expr: if(

only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}

if ((RAG_RATING_CD) = 'R', '1')) =1, 1st Expression)

2nd Expr :

if(

only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}

if ((RAG_RATING_CD) = 'R', '1')) =1, 2nd Expression)

like wise other expression except this one

only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}

if ((RAG_RATING_CD) = 'R', '1'))

Re: Avoiding blanks on pivot table

NavinReddy — Thu, 07 Apr 2016 05:36:37 GMT

Hi Jonathan,

Good Morning, Thanks for your reply

i have tried but still im getting same, i have attached sample application

please suggests me where im doing wrong

Best Regards,

Niranjan

Re: Avoiding blanks on pivot table

NavinReddy — Thu, 07 Apr 2016 05:40:31 GMT

Hi Settu_Periasamy,

Good Morning, Thanks for your reply

its bit confusing me do you want me to write all the conditions at one place

i have attached sample application

suggest me the right way to do ??

Best Regards,

Niranjan

Re: Avoiding blanks on pivot table

settu_periasamy — Thu, 07 Apr 2016 06:27:10 GMT

May be like attached?

Re: Avoiding blanks on pivot table

NavinReddy — Thu, 07 Apr 2016 14:19:40 GMT

Thanks so much its working fine