Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prayag7239
Contributor II
Contributor II

Qliksense value(expression) in qlik n printing designer

Hi all,

I have an straight table in Qliksense. Using it's dimensions and expressions creating Pivot table in Qlik N Printing designer.

While taking expression column as a value in Qlik N Printing designer it shows '1' for each dimension value.

Qliksense expression is not working as a value in qlik n printing designer.

Can anyone help me on this how  to used qliksense expression in qlik n printing designer. 

1 Reply
Dalton_Ruer
Employee
Employee

There is a forum specifically for NPrinting that you should use when posting NPrinting questions so that you get more NPrinting knowledgeable people seeing your posts : https://community.qlik.com/t5/Qlik-NPrinting-Discussions/bd-p/qlik-nprinting-discussions

When you post your question (there or here for general Qlik Sense topics) please help those that are trying to help you by providing screen shots, sample data etc. 

I believe the problem you are experiencing is that the default in EXCEL for a pivot table is that Values use COUNT. You need to manually click on the Values and change to SUM if you want the expression total like below:

Dalton_Ruer_0-1619447161437.png