Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Dynamically Highlighting/Coloring of table line items

I have a table with many different line items (e. g. documents numbers)

 
I want to accomplish a functionality, that allows the user to highlight documents that have already be checked.

What i have in mind is basically a button, which colors the background green or red depending on the result of manual checks for the current selection.

To allow the user to differenciate items that have already been checked from those who have been not.

Any help is appreciated.

Regards

9 Replies

Re: Dynamically Highlighting/Coloring of table line items

Ferhat

If you use a Chart of type Straight or Pivot Table, then in the Chart Properties you'll see a + to left of all the Dimensions and Expressions. 

On expanding this plus you shall see various formatting options including Background & Text Colour, here one can enter an expression like :

     = if ( [YourCheck] = 1 , Green() , Red() )

Then if your button sets a variable, that can also be checked in your expression if statement as per your needs.

Best Regards,     Bill

Not applicable

Re: Dynamically Highlighting/Coloring of table line items

Thank you for your response my difficulty is to realize the dynamic "YourCheck" Variable.

As my check is something done manually outside of qlikview, so i have to somehow get this information (true/ false) into the application via normal user interaction so i can apply the formatting.

sundarakumar
Valued Contributor II

Re: Dynamically Highlighting/Coloring of table line items

Can you please share a sample app.

Am not clear about your requirement.

will the user select the entry and perform check or will he just check without making any selections?
In What type of chart is he going to perform checks?

Not applicable

Re: Dynamically Highlighting/Coloring of table line items

Basic Table example


Document No/ Customer / (or other filter criteria)

1 / A-Customer

2 / B-Customer

3 / C-Customer

4 / A-Customer

5 / B-Customer

6 / C-Customer

User will do a selection based on some filter criteria (e. g. customer A) and get a list of Document No.

1 / A-Customer

4 / A-Customer

These Document No. will be checked outside of qlikview (e. g. look up of an invoice) the result will be

document is correct, is not correct. This information i want to incorporate in the application.

Result

1 / A-Customer / correct = Background green

2 / B-Customer (to be checked yet) = Background white

3 / C-Customer (to be checked yet) = Background white

4 / A-Customer / incorrect = Background red

5 / B-Customer (to be checked yet) = Background white

6 / C-Customer (to be checked yet) = Background white

The idea is to avoid having to export to excel.

sundarakumar
Valued Contributor II

Re: Dynamically Highlighting/Coloring of table line items

I need some more clarifications

1. What is the source for the app? is it an excel?

2. Is The file that the user is going to check, a part of app?

you will have a excel which shows the customers, files and some other fields, this file will be loaded into qlikview and user will select the customer and make some checks in the files that are corresponding to the selected users.(but these files that are going to be checked is not a part of qlikview app). These are my understandings.

Am i correct?

Not applicable

Re: Dynamically Highlighting/Coloring of table line items

Yes this is correct, the files that are going to be checked are not part of the qlikview app.

The source is a financial data extract which is too huge to be processed in excel (plain csv file)

sundarakumar
Valued Contributor II

Re: Dynamically Highlighting/Coloring of table line items

Can the user add the files name that are checked, into an excel manually after the check?

So that this excel can be again reloaded into the app.

Or the users out of your scope?

I dont think there is someother way to give input into the app, that these are checked and these are unchecked.


Not applicable

Re: Dynamically Highlighting/Coloring of table line items

The user is out of scope, the application should bring that functionality if possible. like an Input field per line item

sundarakumar
Valued Contributor II

Re: Dynamically Highlighting/Coloring of table line items


Sorry i dont think there is a possibiliy to mark the things that have been checked in ur case.

Community Browser