Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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?
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.
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?
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)
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.
The user is out of scope, the application should bring that functionality if possible. like an Input field per line item
Sorry i dont think there is a possibiliy to mark the things that have been checked in ur case.