Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. READ MORE

How Can I Display Current Selections in my Reports?

cancel
Showing results for 
Search instead for 
Did you mean: 
Bjorn_Wedbratt
Former Employee
Former Employee

How Can I Display Current Selections in my Reports?

Last Update:

Nov 25, 2015 9:40:27 AM

Updated By:

Bjorn_Wedbratt

Created date:

Nov 25, 2015 9:40:27 AM

Formulas will be used to display NPrinting Current Selections within the report. We will start from a simplified version of the report in the Formulas tutorial. We will add two versions of a formula to display the filters set in NPrinting to be applied.

    
    
        
          

Start with Simple Report

                    
         Start-with-Simple-Report.png                       
        
        
        
          

Add Unformatted Formula

                    
       Add-Unformatted-Formula.png                         
          

This formula queries for the current selections.

        
        
        
          

Add Formatted Version

                    
         Add-Formatted-Version.png                       
          

This formula queries for the current selections but with different separators. QlikView Help explains that chr(13), carriage return, causes a new paragraph. The first combination of characters between single quotes ' = ' (space, equal sign, space) defines the separator between the field name and the list of values, and the second '; ' (semicolon, space) defines the separator between field values.

        
        
        
          

Embed Formulas in Template

                    
          Embed-Formulas-in-Template.png                      
          

Drag the Current Selections and Current Selections with Separator node tokens into the template and drop them into empty cells. Save, Close, and Preview.

        
        
        
          

Report Displays Current Selections

                    
          Report-Displays-Current-Selections.png                      
          

You can see the difference in effect between the default values and the custom values.

        
        
    
  
Comments
agni_gold
Specialist III
Specialist III

Hi friends ,

I am facing issue with current selection box in nprinting report, i have created formula in nsq file as getcurrentselection function and added to nprinting report , so only year and month are coming but other field selection are not coming , please help me why other filed are not coming in my current selection .

I have checked in my template also , in my PPT template there are two slides , but when i am trying current selection formula at first slide it is working. But when using in second slide it is only showing year and month selection in as current selection not other fields.

Version history
Last update:
‎2015-11-25 09:40 AM
Updated by: