Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
khanashique
Contributor II

Set expression on row level

Hi experts,

I have define a set expression which works on specific condition, but it doesn't work on row level without condition:

eg: (sum({<Year = {2017},Item = {'Books'}>}sales)-sum({<Year = {2018},Item = {'Books'}>}sales))*sum({<Year = {2018}>}amount) --> this expression works.

but the same expression on row level in a table without condition doesn't gives the expected result.

eg: (sum({<Year = {2017}>}sales)-sum({<Year = {2018}>}sales))*sum({<Year = {2018}>}amount) --> this expression works.

Do i need to add some other expression to my current set expression, kindly advise.

 

Thanks,

MAK.

1 Solution

Accepted Solutions
khanashique
Contributor II

Re: Set expression on row level

i was able to solve the expression, please see below:

sum(<Item>sales)/sum(<Item>amount)

3 Replies

Re: Set expression on row level

You have only Item dimension or anything else?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
khanashique
Contributor II

Re: Set expression on row level

One item condition was just an example, to check if the expression works...

khanashique
Contributor II

Re: Set expression on row level

i was able to solve the expression, please see below:

sum(<Item>sales)/sum(<Item>amount)