set analysis filling

[Anonymous]

Hi everyone,

Today, im stuck whithin my qlikview report 😕

im trying to fill one specific cell from an other one with set analysis,

Here an exemple :

Letter     price      Size     price2

A         100          Tall            ...  

B          30          Small          ...    

C          50          Thin            ...

what i wanna do is to fill the fourth column with the second column value of C (50) like :

Letter     price      Size     price2

A         100          Tall            50

B          30          Small          50

C          50         Thin            50

So i tried this set analysis whitout any succes :

Sum({$<[Letter]={"C"}>} [price])

Does anyone get the same issue ?

[sunny_talwar · Accepted solution]

Try this

Sum(TOTAL {$<[Letter]={"C"}>} [price])

[Chanty4u]

may be this  qualifier ?

Sum(Total {$<[Letter]={"C"}>} [price])

[shiveshsingh]

Try this :  sum(TOTAL{<Letter={'C'}>}price)

[shiveshsingh]

Hi Sunny

what's the difference if i use single quotes?

sum(TOTAL{<Letter={'C'}>}price)

[sunny_talwar]

In this case, none... but I think single quote is preferable... but for a search statement like this {"C*"}.. I would use double quotes because of the new Quotology  Quotes in Set Analysis‌

[shiveshsingh]

Okie, thanks

[Anonymous]

Thanks you guys, everythings is fine now