Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
NavinReddy
Contributor II

Avoiding blanks on pivot table

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

1 Solution

Accepted Solutions
Highlighted

Re: Avoiding blanks on pivot table

May be like attached?

View solution in original post

14 Replies
Highlighted

Re: Avoiding blanks on pivot table

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)

Highlighted
NavinReddy
Contributor II

Re: Avoiding blanks on pivot table

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)

Highlighted

Re: Avoiding blanks on pivot table

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

Highlighted
NavinReddy
Contributor II

Re: Avoiding blanks on pivot table

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

Highlighted
NavinReddy
Contributor II

Re: Avoiding blanks on pivot table

=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

Highlighted
Chanty4u
Esteemed Contributor III

Re: Avoiding blanks on pivot table

hi,

Load

if (Fieldname <> 0,FieldName) as Fieldname

Highlighted
NavinReddy
Contributor II

Re: Avoiding blanks on pivot table

Hi Chanty,

its not actually blanks

im trying to displaying only Tier1(pink) columns

Thanks,

Niranjan

Highlighted
NavinReddy
Contributor II

Re: Avoiding blanks on pivot table

Dear Experts, Any suggestion

Highlighted
MVP
MVP

Re: Avoiding blanks on pivot table

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein