qlikview
Group values in one label in qlikview
I have a field which is named: grupo it contains this values: Repairs & Maintenance . . . a lot of values I want to choose just the important thing and group all the other in autres: Other and calculate the total.
How can I do that in qlikview
Solution
I can advise you to make this in the script - create new field in the same table where grupo field is. The new field should be based on mapping table or something like this: if( match( grupo, 'ICMS','PENALTY' ) > 0, grupo, 'Other') as grupo1
- How can i get a Qlik app layout as XML/JSON File?
- Using version control systems with QlikView
- Is there a way to read Qlikview data object using R and perform an statistical operation and return results to Qlikview?
- Unable to get comma separated values in Qlik text box for a certain logic
- Compare the data sets coming from two set expression in Qliksense
- Qlik left join to the same table - how it works in SQL?
- QlikView Direct Discovery - WHERE clause
- QlikView Direct Discovery
- (Very)Large QVD file to pandas DataFrame
- I need only one manager to correspond to each branch + client bundle, otherwise after Joining, I will get extra lines in the report
- What is the alternative of PEEK() function in Qlik in ATHENA AWS?
- QlikView/QlikSense: Transforming Column with Lots of Strings
- Export QlikSense application (QVF) file to a PRJ folder
- QlikSense, how to make a piechart where the value for the pie chart is the sum of multiple summed columns, and the slices are the columns
- Calculating the threshold date - Qliksense function
- How to clear memory from a qlikview document programmatically?
- Issue encountered during reload process: Field 'supplier_key' not found
- QVConnect.exe causes out-of-memory error in QlikView using SAP OLAP Connector
- Qlik Sense: Sum by Distinct id
- QlikView File not found error Cannot open file
- How do I make a filter pane appear as a Drop down menu in Qlik Sense?
- Qlik Sense: Understanding what this summation expression does
- SQL - Is there a way to access the previous row in the same column that's currently being created? Similar to Peek() function in QLIK
- I need Excel VBA to wait until Qlikview finishes working
- QlikSense Set Analysis - Sum Less than HH:MM Format
- Create a single dimension from multiple fields
- The right API/scrape method to extract tables from a Qlikview app
- How to remove records when ID has at least one related measure = 0
- What does "+1" mean in the following Qlik expression
- Create a dynamic list of tables used by all the dashboards on the server