Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Dynamically Change Dimension and Grouping Expression in Cumulative calculation

Hi All

I need urgent help on this please:

I have data like below,

PeriodClassGroupNo of Intake
Jan1VM5
Jan2VM2
Jan3ST3
Jan4ST3
Feb1VM2
Feb2VM2
Feb3ST1
Feb4ST5
Mar1VM3
Mar2VM1
Mar3ST1
Mar4ST3
Apr1DC2
Apr2DC2
Apr3DC1
Apr4LP2
Apr5LP3

Now, In Jan Yearly Total Intake by Group Report Should Show,

GroupYTD Intake
VM7
ST6

Because, VM total = Class 1 + Class 2 and ST Total = Class 3 + Class 4

Similarly,

Feb Report will be :

GroupYTD Intake
VM11
ST12

Mar Report will be:

GroupYTD Intake
VM15
ST16

But interesting will be the report of Apr, where re grouping caused, Class 1, 2 & 3 to be under DC and Class 4 under LP and a new class introduced which is class 5 and that also is under LP.

Now for Apr report, YTD Total for DC will be = YTD total of Class 1 + YTD Total of Class 2 + YTD Total of Class 3; Similarly LP Total = YTD Total of Class 4 + YTD Total of Class 5;

And the report should be as:

GroupYTD Intake
DC25
LP14

I've no Clue how to display this. Would you kindly help?

4 Replies
er_mohit
Honored Contributor II

Re: Dynamically Change Dimension and Grouping Expression in Cumulative calculation

hii

see the attached file

in LP i count its 16 not 14

Re: Dynamically Change Dimension and Grouping Expression in Cumulative calculation

See attached example.


talk is cheap, supply exceeds demand
Not applicable

Re: Dynamically Change Dimension and Grouping Expression in Cumulative calculation

Thank You so much... Your answer is really very helpful. May I please ask (as the requirement is changing a little)

how to generate the report based on the range of Periods selected; For example If from Period List box, I select Feb Mar & Apr then report should exclude Jan Valuse but will show result as per latest Group Structure?

Feb + Mar + Apr ::

GroupTotal Intake
DC15
LP13

Same way, if say I select Jan and Feb: then result should be::

GroupTotal Intake
VM13
ST12
Not applicable

Re: Dynamically Change Dimension and Grouping Expression in Cumulative calculation

Thank You so much... Your answer is really very helpful. May I please ask (as the requirement is changing a little)

how to generate the report based on the range of Periods selected; For example If from Period List box, I select Feb Mar & Apr then report should exclude Jan Valuse but will show result as per latest Group Structure?

Feb + Mar + Apr ::

GroupTotal Intake
DC15
LP13

Same way, if say I select Jan and Feb: then result should be::

GroupTotal Intake
VM13
ST12
Community Browser