Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Creating new Dimension members based on Set Analysis Measure Value

Hi All,

  I am new to Qlik Tool and Community.And I am us Qlik Sense in my Current Project. I am facing problem, to create a Dimension based on result of measure Derived from Set analysis.

Like Suppose I need Dimension like if Measure >=15, then ">15", else if Measure >=5 then ">5" else Others. So I want to group Dimension based on Measure derived from Set Analysis.

Regards

Sateesh

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Creating new Dimension members based on Set Analysis Measure Value

This is a way how it could be done within qlikview: Load script full variable. maybe this could be adapted anyway.

- Marcus

Highlighted
MVP
MVP

Re: Creating new Dimension members based on Set Analysis Measure Value

You could define a calculayed dimension like this:

=Aggr(If(Sum(Measure) > 15, Dual('>15', 15),

  If(Sum(Measure > 5, Dual('>5', 5),

  Dual('Others', 0)))), <... underlying dimension ...>)

Where <... underlying dimension ...> is the dimension field (or fields) by which the measure should be calculated

But both calculated dimensions and nested ifs can be performance killers, so if your data set is large, you may want to implement this logic in the load script and create a new field with these values.

I used duals in the expression above so that the values will correctly sort in your chart/table.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein