Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

DeepuMouni
New Contributor

Dynamically Calculated Measure to Plot TreeMap

Hi,

I am calculating a measure calculated dynamically based on other measures and has rangesum and after functions..is it possible to plot Treemap for this dynamically calculated measure?

Any hints or suggestions on this is much appreciated. Thank you!

Below Example is the dynamically calculated measure(JKQ) from ABC,XYZ & DEF and Using Rangesum and after

JKQ =

if(
Sum({$<[DATA_MEASURE]={'ABC'},WEEKLY_VERSION={'$(=vVersionselection)'}>}[VALUE])=0,0,
if(
RangeSum(after(Sum({$<[DATA_MEASURE]={'XYZ'},WEEKLY_VERSION={'$(=vVersionselection)'}>}[VALUE]),0,3))=0,99999,
if(
Sum({$<[DATA_MEASURE]={'ABC'},WEEKLY_VERSION={'$(=vVersionselection)'}>}[VALUE])<=0,0,
Sum({$<[DATA_MEASURE]={'ABC'},WEEKLY_VERSION={'$(=vVersionselection)'}>}[VALUE])
/
(
RangeSum(after(Sum({$<[DATA_MEASURE]={'XYZ'},WEEKLY_VERSION={'$(=vVersionselection)'}>}[VALUE]),0,3))
/
RangeSum(after(Sum( distinct {$<[DATA_MEASURE]={'DEF'},WEEKLY_VERSION={'$(=vVersionselection)'}>}[VALUE]),0,3)))
)
)
)