How to create Dynamic values in dimension

[MilkyWay]

Hi Community!

I need to get table with dynamic values depend on dates (Customer Name must be change):

Dim	Expr
DateBegin	Sum(Sum_DateBegin)
CustomerName_Top1	Sum(Sum_DateBegin) - Sum(Sum_DateEnd)
CustomerName_Top2	Sum(Sum_DateBegin) - Sum(Sum_DateEnd)
DateEnd	Sum(Sum_DateEnd)

I tried to use ValueList in dimension and pick(Match(ValueList(...))) in Expression, but I have error.

Have you any ideas?

[datagrrl]

I have attached a file of what I think your data might look like.

I think the key is using the =$(=Expr) Expression

[MilkyWay]

Thank You! Unfortunatly I can't open qvf file, I use qlikview. Can you change  format of your attach?

[Kushal_Chawda]

@MilkyWay  Create below dimension using valuelist()

=valuelist('DateBegin','CustomerName_Top1','CustomerName_Top2','DateEnd' )

Use below expression

Pick(

match(

valuelist('DateBegin','CustomerName_Top1','CustomerName_Top2','DateEnd' ),

'DateBegin',
'CustomerName_Top1',
'CustomerName_Top2',
'DateEnd'),

Sum(Sum_DateBegin),
Sum(Sum_DateBegin) - Sum(Sum_DateEnd),
Sum(Sum_DateBegin) - Sum(Sum_DateEnd),
Sum(Sum_DateEnd)

)

[MilkyWay]

Thank you, ValueList  takes only static names, but I need to recive real names of customers and dates which will be  change depend of choosing dates in calendar. For example:

Whole Sum 01/08/2024

Mr A = different between Sums top 1

Mr B= different between Sums top 2

Whole Sum 30/08/2024

01/07/2024

Mr C

Mr D

31/07/2024

[Kushal_Chawda]

@MilkyWay  check the attached qvw file. I have used cyclic group. You can change dimensions in cyclic group and expression of dimension according to your need