Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
efv_infodata
Partner - Contributor II
Partner - Contributor II

SetAttribute and sub-SetAttribute(Sum({<...>})=0)

hello,

I need some help to build a setattribute with sub-setattribute.

My model is simple.

doc:

Customer,

Year,

YearAgo ( load from year(Today() - Year)

Sales;

I'll found my 're-born' Customer; the one who have Sales on YearAgo=0 and without Sales on Yeargo=1

Here is my formula

Sum({$<YearsAgo={0},   Customer={" =Sum({$<YearsAgo={1}>} Sales)={0}" } > } Sales)

but I get 0.00 ... sure there is some.

What's wrong on the syntax?

Thanks for any help.

Manu

1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum({$<YearAgo = {0}, Customer = e({<Customer = {"=Sum({$<YearAgo = {1}>} Sales) > 0"}>})>} Sales)

or this

Sum({$<YearAgo = {0}, Customer = e({$<YearAgo = {1}>})>} Sales)

View solution in original post

5 Replies
sunny_talwar

Try this

Sum({$<YearsAgo = {0}, Customer = {"=Sum({$<YearsAgo = {1}>} Sales) = 0"}>} Sales)

efv_infodata
Partner - Contributor II
Partner - Contributor II
Author

sorry, it did'nt work....

doc:

load

  Customer,

  Year,

  year(today()) - Year as YearAgo,

  Sales

inline [

Customer,Year,Sales

a,2018,200

a,2017,200

b,2018,300

c,2017,100

];

qlik ReNew biz.PNG

sunny_talwar

Try this

Sum({$<YearAgo = {0}, Customer = e({<Customer = {"=Sum({$<YearAgo = {1}>} Sales) > 0"}>})>} Sales)

or this

Sum({$<YearAgo = {0}, Customer = e({$<YearAgo = {1}>})>} Sales)

efv_infodata
Partner - Contributor II
Partner - Contributor II
Author

I got it !

You can't select what is does'nt exist...

I must 'exclude' what's exist....

thank you for your help.

sunny_talwar

You got it