Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Calculation Condition

Hi - I have a pivot table which I want to disable whenever a value in field is not deselected.

So I have field - SECTOR -  which has 3 possible values - A, B or C,  if C is not deselected I don't want the pivot to calculate.

Thanks in advance!

Nandy

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Try this as calculation condition: =If(max(match(SECTOR,'C')),0,1)


talk is cheap, supply exceeds demand

View solution in original post

3 Replies

Will you able to explain little more, Please?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP & Luminary
MVP & Luminary

Try this as calculation condition: =If(max(match(SECTOR,'C')),0,1)


talk is cheap, supply exceeds demand

View solution in original post

Contributor III
Contributor III

That looks like it's doing the job!

Thanks for the quick response!

Nandy