topic Re: How to hide row(s) based on condition in Pivot Table. in QlikView

How to hide row(s) based on condition in Pivot Table.

Anonymous — Thu, 21 May 2015 09:31:18 GMT

Hi I have created a pivot table like below with sample data. but when ROLE has more than one SPECIALZATION then that complete ROLE has to hided.

i.e., in the below example "EG Service Provider ISR" has to be removed as contains more than one (i.e,, two) SPECIALZATION.

Currently We have like this.

We wanna remove like below:

So Result is like this:

Note: This would be dynamic, not static.

I attached sample QVW and Source for the same. please do changes accordingly. Please do reply early.

Thanks,

Re: How to hide row(s) based on condition in Pivot Table.

Anonymous — Thu, 21 May 2015 09:50:50 GMT

try using aggr function

Ex.

=if(aggr(count([SPECIALZATION-2]),SALESROLE)=1,if(isnull([SPECIALZATION-2]),'False','True'))

you may need to see your dimension used in aggr

Thanks

BKC

Re: How to hide row(s) based on condition in Pivot Table.

Anonymous — Thu, 21 May 2015 10:00:26 GMT

Hi BalKumar,

Can you please apply the same above condition on QVW file and attach to this.

Thanks,

Re: How to hide row(s) based on condition in Pivot Table.

tresB — Thu, 21 May 2015 10:10:51 GMT

Like in attached qvw?

Re: How to hide row(s) based on condition in Pivot Table.

Anonymous — Thu, 21 May 2015 10:19:20 GMT

Hi Tresesco,

Thank You.

Exactly what I am looking for it.

Thanks

Re: How to hide row(s) based on condition in Pivot Table.

Anonymous — Thu, 21 May 2015 19:14:07 GMT

Hi Tresesco And All,

I have one more need that, the deleted(hided) data has to be displayed in a separate table like below:

If a SALESROLE is having more than one SPECIAZATION-values then that data has to be showned in a separated table dynamically(not statically)

i.e,. like below:

Result-Table:

Please suggest me, and attach the solved qvw file.

Thanks.

Re: How to hide row(s) based on condition in Pivot Table.

tresB — Fri, 22 May 2015 04:27:07 GMT

PFA.

Mark the correct reply as 'Correct'/'Helpful', that would help others find the right answer easily and points would go to the deserving person.

Re: How to hide row(s) based on condition in Pivot Table.

Anonymous — Fri, 22 May 2015 05:12:18 GMT

Thank you Tresesco, your input is the one what I am looking for.....

Please let me know the process of Marking as "CORRECT/HELPFUL", if I'm not following correctly( guide me if any thing not following correctly)

Thank,

Re: How to hide row(s) based on condition in Pivot Table.

tresB — Fri, 22 May 2015 05:18:37 GMT

Not an issue, let me explain:

You marked your own reply as Correct which is not. You should have marked one of my replies as correct and another as helpful. Because your reply :

Hi Tresesco,

Thank You.

Exactly what I am looking for it.

is not actually the correct reply to your post. Hope that helps.

Re: How to hide row(s) based on condition in Pivot Table.

Anonymous — Fri, 22 May 2015 05:54:04 GMT

Hi Tresesco,

Right now I followed the correct way on "HelpFul/Correct" right?

Please improvise me to follow correct process.

Thanks,

Rak