topic Re: Data distribution in QlikView

Data distribution

Denchik — Sat, 11 May 2019 08:23:35 GMT

HI All,

I have been searching on the community and have found similar examples but nothing that will quite do what I require.

Benchmark data
load *

inline
[
Product, Type,   P,       Z
Banana, T1,       100,      0.4
Banana, T2,       0, 0.6
];

Formula for distribution
if(Type= 'T1', Sum({<Type= {'T1'}>}P)*only({<Type= {'T1'}>}Z),
         if(Type= 'T2', Sum({<Type= {'T2'}>}P)*only({<Type= {'T2'}>}Z)     ,1))

But I can not distribute where there is no source data.

I will appreciate any help.

Thank You

Re: Data distribution

Anil_Babu_Samineni — Sat, 11 May 2019 08:30:59 GMT

Try this?

If(Type= 'T1', Sum({<Type= {'T1'}>} P*Z), If(Type= 'T2', Sum({<Type= {'T2'}>}P*Z), 1))

Pick(Match(Type, 'T1', 'T2')+1, Sum({<Type= {'T1'}>} P*Z), Sum({<Type= {'T2'}>}P*Z), 1)

Re: Data distribution

Denchik — Sat, 11 May 2019 08:46:13 GMT

It doesn't work either.

Re: Data distribution

Anil_Babu_Samineni — Sat, 11 May 2019 08:47:57 GMT

What is the O/P you want to see? and where are you trying?

Re: Data distribution

Denchik — Sat, 11 May 2019 09:15:27 GMT

QlikView 11,20, Summary Table .
Т1 = 100 * 0,4 = 40
Т2 = 100 * 0,6 = 60