Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I have attached a file of what I think your data might look like.
I think the key is using the =$(=Expr) Expression
Thank You! Unfortunatly I can't open qvf file, I use qlikview. Can you change format of your attach?
@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)
)
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
@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