Dynamic value in variable

[manideep78]

Dear Community,

I want to get the value dynamically in a variable based on a condition.

K	v	Value
2	1	63.7
2	2	9.92
2	3	5.84
2	4	4.6
2	5	4.03
3	1	95.7
3	2	13.4
3	3	7.51
3	4	5.74
3	5	4.93

The condition is like if K=2 and v=1 then 63.7.

like this i have to get the value stored in the variable based on a condition.

above table is a sample table. The original table consists of 1000 records. I have to look at all the conditions and then get the value in the variable.

Please let me know how can we achieve this.

Thanks in advance.

Regards,

Manideep

[vardhancse]

Hi,

even though the data is more we can maintain separate condition for each one dimension/expression.

so while creating the variable, add the condition and create different variables.

or

Attach a sample QVW, so that we can understand easily.

[sunny_talwar]

May be this:

vVar: =Only({<K = {"$(=Concat(DISTINCT K))"}, v= {"$(=Concat(DISTINCT v))"}>}Value) or

vVar: =Only({<K = {"$(=GetFieldSelections(K))"}, v= {"$(=GetFieldSelections(v))"}>}Value)

Based on your selection in K and v list box, the value of vVar will change

[manideep78]

Hi

Here I need to compare expression values with K and V.

K -  count(DISTINCT ITEM)

V- Count(DISTINCT Customers)

so, if( K = count(DISTINCT ITEM) and V= Count(DISTINCT Customers), Value)

             k =2 and V=3, then 5.84

Note: I don't have ITEM and Customers as filters. I do not want to add those filters.

[sunny_talwar · Accepted solution]

If Item and Category are fields then may be this:

=Only({<K = {"$(=Count(DISTINCT ITEM))"}, v= {"$(=Count(DISTINCT Customers))"}>}Value)

[manideep78]

I tired, but no luck

[sasiparupudi1]

Please post your application

[manideep78]

got it. Thanks sunindia‌