topic Re: Dynamic value in variable in QlikView

Dynamic value in variable

manideep78 — Fri, 14 Aug 2015 10:12:47 GMT

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

Re: Dynamic value in variable

vardhancse — Fri, 14 Aug 2015 10:15:49 GMT

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.

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

Re: Dynamic value in variable

sunny_talwar — Fri, 14 Aug 2015 10:18:01 GMT

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

Re: Dynamic value in variable

manideep78 — Fri, 14 Aug 2015 10:55:28 GMT

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.

Re: Dynamic value in variable

sunny_talwar — Fri, 14 Aug 2015 11:10:29 GMT

If Item and Category are fields then may be this:

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

Re: Dynamic value in variable

manideep78 — Fri, 14 Aug 2015 11:19:06 GMT

I tired, but no luck

Re: Dynamic value in variable

sasiparupudi1 — Fri, 14 Aug 2015 11:20:40 GMT

Please post your application

Re: Dynamic value in variable

manideep78 — Fri, 14 Aug 2015 12:08:15 GMT

got it. Thanks sunindia‌