Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Moti_Mach
Contributor
Contributor

Using Variable on set analsys

Hallo,

i'm trying to build expression using set analsys for specific variable value but didnt succeed.

i didnt find anything similar on furom:

for ex:

i want to sum( Amount_USD) only for vLineDesc='A':

i try this but its not working....  

Sum(${<$(vLineDesc)={'A'}>}Amount_USD)

i'll appriciate your help.

moti.

 

Labels (1)
4 Replies
lironbaram
Partner
Partner

hi 

variable aren't connected to the data

so using them in set analysis want do anything for your calculations 

set analysis is practically making selections in the data , 

so you need to use a field in your set analysis

Sue_Macaluso
Community Manager
Community Manager

Hi @Moti_Mach Are you using QlikView or Qlik Sense? I would like to move your post into the correct product forum. 

Sue Macaluso
Moti_Mach
Contributor
Contributor
Author

HI,

Qlikview.

 

tx

 

moti

Brett_Bleess
Support (Former)
Support (Former)

Moti, have a look at the following Design Blog post, there are subsequent links to other posts at the bottom of this one, just FYI, hopefully this may be helpful to you in getting things sorted out on this one.  You may need to attach a sample application otherwise, so folks can see exactly what you are doing in relation to your data model and the variable in question.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.