Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

for each row want its value

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)

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

1 Reply

Re: for each row want its value

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


talk is cheap, supply exceeds demand
Community Browser