7 Replies Latest reply: Oct 7, 2015 6:56 AM by Andrea Ghirardello RSS

    can nprinting display some of the columns from a chart used in Qlikview?

    Mina Patel

      I have table in a qlikview document with columns C to Q(see attached) when I use this chart in my Qlikview document all columns in my table is shown to only select users. Then for others columns K to Q are hiddden for other users. I want the same to happen when I distribute the results via nprinting.


      How can this be done?chart.png

      Thanks in advance.

       

        • Re: can nprinting display some of the columns from a chart used in Qlikview?
          Andrea Bertazzo

          Thanks for the good question. At the moment there is not the possibility to show an abject or a part of it in a report. NPrinting filters are created to select part of the data but cannot be used to hide columns.

          Moreover, it is not possible to use QV conditional formatting because NPrinting imports also hidden charts.

          • Re: can nprinting display some of the columns from a chart used in Qlikview?
            Andrea Ghirardello

            Hi,

             

            Not sure about how you managed hidden columns but I hope that one of the different approaches used in the attached document can fit your needs.

             

            Approach 1 (upper left): Variables

            The chart contains as much dimensions and expressions as you need to show. You can choose which content to show (which fields and which values) by setting four variables values (two for the dimension and two for the expression)

             

            QlikView NPrinting

            Template Editor: Just drag and drop the chart tag (not single columns)

            Recipient: associate to each recipient a filter based on variables.

             

            Pro:

            - dynamic chart with regards of content

            - different filters may be imported and associated to recipients automatically with Repicient imports

             

            Cons:

            - static chart with regards of the number of dimensions/expressions

            - need to create a different filter for each combination of dimensions/expressions you want to show

             

             

            Approach 2 (upper right): Conditional dimensions/expressions (QV >= 11)

            The chart contains as much dimensions and expressions as you might need to show. You can choose which ones to show

             

            QlikView NPrinting

            Template Editor: Just drag and drop the chart tag (not single columns)

            Recipient: associate to each recipient a filter based on fields that select which dimensions and expressions to show.

             

            Pro:

            - dynamic chart with regards of number of dimensions/expressions

            - different filters may be imported and associated to recipients automatically with Repicient imports

             

            Cons:

            - static chart with regards of the content of dimensions/expressions (you can choose whether show or not certain ones...but the content has been defined previously)

            - need to create a different filter for each combination of dimensions/expressions you want to show

             

             

            Approach 3 (bottom): uses expressions

            You could create a chart with a wide number of dimensions and expressions based on formulas that pick the content from fields that you select with NPrinting Filters.

             

            E.g.

            =pick(

            match(Title_Column,'Sales','Budget','Diff. Sales/Bdg','Diff. Sales/Bdg %'),

            num(sum(Sales),'#.##0',',','.'),

            num(sum(Budget),'#.##0',',','.'),

            num(sum(Budget),'#.##0',',','.')-num(sum(Sales),'#.##0',',','.'),

            num(sum(Sales),'#.##0',',','.')/num(sum(Budget)*100,'#.##0',',','.'))

             

            QlikView NPrinting

            Template Editor: Just drag and drop the chart tag (not single columns)

            Recipient: associate to each recipient a filter based on fields that select which dimensions and expressions to show.

             

            Pro:

            - dynamic chart with regards of number of dimensions/expressions

            - different filters may be imported and associated to recipients automatically with Recipient imports

             

            Cons:

            - need to create a different filter for each combination of dimensions/expressions you want to show

             

            Approach 4: mix of 1 and 2

            You could create a chart with a wide number of dimensions and expressions based on variables, configure these variables with formulas that pick the content from fields that you select with NPrinting Filters.

             

            QlikView NPrinting

            Template Editor: Just drag and drop the chart tag (not single columns)

            Recipient: associate to each recipient a filter based on fields that select which dimensions and expressions to show.

             

            Pro:

            - dynamic chart with regards of number of dimensions/expressions and content. No need to know previously the formulas in QlikView...you can decide them when creating filters in QlikView NPrinting

            - different filters may be imported and associated to recipients automatically with Repicient imports

             

            Cons:

            - need to create a different filter for each combination of dimensions/expressions you want to show