Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

hightlighting rows in a table based on condition

I'm brand new to Qlikview.....

I have a list that includes company names and addresses.    Another data element includes customer preference for US vs International.

How can I limit the addresses that show up based on the pre-populated value of customer preference?

2 Replies

Re: hightlighting rows in a table based on condition

Could you provide samples?

MVP
MVP

Re: hightlighting rows in a table based on condition

Hi Rick,

welcome to QlikView, I'm sure you are going to love it!

First of all, highlighting is different than limiting the list. I'll address the "limiting" question...

If this is a straight table (form of a chart), you can limit the list by applying a Set Analysis condition to all chart Expressions. For example:

Count({<Preference = {US}>} CustomerID)

You can hide this Expression using the Presentation tab if it's not needed.

I don't think there is a good way to limit a Table box to the same condition.

Another, perhaps more basic solution, is to let the user make a Selection in the Preference field. Then, both the chart and the table box get limited to the selected value by default.

cheers,

Oleg Troyansky

Come and learn Set Analysis and Advanced Aggregation with me at www.masterssummit.com - take your QlikView skills to the next level!

Community Browser