Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Contributor
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

Try this

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

View solution in original post

7 Replies
Highlighted

Try this

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

View solution in original post

Highlighted
Champion III
Champion III

may be this  qualifier ?

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

Highlighted
Master
Master

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

Capture.JPG

Highlighted
Master
Master

Hi Sunny

what's the difference if i use single quotes?

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

Highlighted

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
Master

Okie, thanks

Highlighted
Contributor
Contributor

Thanks you guys, everythings is fine now