topic How to create Dynamic values in dimension in QlikView

How to create Dynamic values in dimension

MilkyWay — Tue, 10 Sep 2024 15:00:43 GMT

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?

Re: How to create Dynamic values in dimension

datagrrl — Tue, 10 Sep 2024 14:29:43 GMT

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

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

Re: How to create Dynamic values in dimension

MilkyWay — Tue, 10 Sep 2024 14:57:38 GMT

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

Re: How to create Dynamic values in dimension

Kushal_Chawda — Tue, 10 Sep 2024 15:34:56 GMT

@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)

)

Re: How to create Dynamic values in dimension

MilkyWay — Tue, 10 Sep 2024 17:57:08 GMT

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

Re: How to create Dynamic values in dimension

Kushal_Chawda — Tue, 10 Sep 2024 18:12:36 GMT

@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