Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is really simple for all of you Pro's out there.
In my excel file, that has been uploaded into Qlik, each row is labeled either "Include" and "Exclude."
In Qlik, how do I exclude the rows that are labeled "Exclude" from being calculated in my dashboard. Can I use a filter....or do I have to write an equation?
It depends on what you need to do.
Both are possible and correct.
Set analysis(equation): QlikView Tutorial | QlikView Set Analysis | QlikView Filter Types and Set Operators - YouTube
Please provide sample data and description of the need, might be more helpfull.
Best Regards,
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
do you need the rows = 'exclude' in the application? Because you could just exclude them in your script.
LOAD
*
FROM excel_file
where not match(label_name,'Exclude');