Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Non Aggregated Measure in Pivot or Chart

tschullo
Creator III
Creator III

Non Aggregated Measure in Pivot or Chart

When adding a measure to a pivot or data chart, you can search for the field you want, but when you select it you are forced to pick an aggregation function to go with it, i.e. SUM, COUNT, AVG, MAX, MIN.  Many times the measure is text and I just want to enter it alone without aggregation for various reasons including not wanting to have a search icon like dimensions because it's not a field users would search in.  Do all measures really have to be measurable? 

I would like the drop down option allow me to select the field as is without aggregation instead of having to either type it in manually and click enter, or select sum and then go edit sum out.

5 Comments
tschullo
Creator III
Creator III
Henric Cronström call these "Naked References" and discourages the use of them. Behind the scenes they get wrapped in an Only() statement. but given the fact that they are possible, why make it so difficult?
John_Teichman
Former Employee
Former Employee

Hello @tschullo,

Thanks for your post. Please use one, and only one, label when submitting an idea. Refer to the submission guidelines for more details.

Patric_Nordstrom
Employee
Employee

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,
Patric

Status changed to: Open - Collecting Feedback
Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived