Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yangcelinexu
Contributor

New measure caculation

Hi,

I have a products hierarchy here : Category--Subcategory--Product name, the measure is daily Sales

I want to create the line chart, have a line represent the 'overall Subcategry' performance as benchmark,(average (all product performance))

and then have other lines represent individual 'Product performance'


so I think I need to create a new measurement. Where could i find more info regarding how to create this type of new columns?

Currently, i am using R do the data processing first and then move in to Qliq sense cloud for visual. Any chance I can achive most of calculation within Qlik sense? want to learn more.



But, if that possible,  that needs to be dynamic according to the subcategory I choose. Is that possible?


or I have to calculate all the single Subcategory sales first, then place them in the database and tag it within the Subcategory

then visualize it?

Regards,

Celine

Tags (1)
Community Browser