for each row want its value

Wed, 20 May 2015 06:15:24 GMT

There Straigh Table 8 rows by 8 columns.

In each row and column information from its database

Column 1 - field Fp - just a list from 1 to 8

F_prm and R_prm taken from the base value of from 1 to 8.

No matter how trying to use a subset of Expression , I can not substitute the value of Fp or RowNum () inside the set.

We have to use such a misery, listing line number (Fp), and if it means 1, the inside of the set to expose 1, 2 -> 2, etc. nt ({$ <F_prm = { 1 }, R_prm = {8}> } DISTINCT Client)


if (Fp=1, Count({$ <F_prm={1}, R_prm={8}>} DISTINCT Клиент), 
  if(Fp=2, Count({$ <F_prm={2}, R_prm={8}>} DISTINCT Клиент), 
  if(Fp=3, Count({$ <F_prm={3}, R_prm={8}>} DISTINCT Клиент), 
  if(Fp=4, Count({$ <F_prm={4}, R_prm={8}>} DISTINCT Клиент), 
  if(Fp=5, Count({$ <F_prm={5}, R_prm={8}>} DISTINCT Клиент), 
  if(Fp=6, Count({$ <F_prm={6}, R_prm={8}>} DISTINCT Клиент), 
  if(Fp=7, Count({$ <F_prm={7}, R_prm={8}>} DISTINCT Клиент), 
    if(Fp=8, Count({$ <F_prm={8}, R_prm={8}>} DISTINCT Клиент)))))))))

Maybe somehow we can make Expression one line:

Count({$ <F_prm={1}, R_prm={8}>} DISTINCT Клиент)

and instead F_prm = { 1 } or substituted RowNum () or Fp?

Construction (and a lot of different or similar)

Count({$ <F_prm={$(RowNum())}, R_prm={8}>} DISTINCT Клиент)

Count({$ <F_prm={$(Fp)}, R_prm={8}>} DISTINCT Клиент)

Count({$ <F_prm={Num(Fp)}, R_prm={8}>} DISTINCT Клиент)

do not pass

Re: for each row want its value

Gysbert_Wassenaar — Thu, 21 May 2015 07:19:57 GMT

It sounds like your data model should be modified, but I don't know what it looks like and to be honest I don't understand what you're trying to do. Perhaps this document helps: Evaluating "sets" in the context of a dimension

topic Re: for each row want its value in QlikView

for each row want its value

Re: for each row want its value