# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Contributor

## set analysis filling

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 ?

1 Solution

Accepted Solutions
Highlighted
MVP

Try this

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

7 Replies
Highlighted
MVP

Try this

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

Highlighted
Champion III

may be this  qualifier ?

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

Highlighted
Master

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

Highlighted
Master

Hi Sunny

what's the difference if i use single quotes?

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

Highlighted
MVP

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

Highlighted
Master

Okie, thanks

Highlighted
Contributor

Thanks you guys, everythings is fine now