Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Ignore dimension in set analysis | Qlik Sense

Hi,

I am wondering what type of syntax I would use if I want return values outside of the dimension. E.g. for the following source data...

DaySales
110
211
312
Total33

...if I wanted to show a table with the relative sales as a percentage each day, so as to return the following.

DaySales (%age)
130.3%  (10/sum of total sales, i.e. 33)
233.33%
336.4%
Total33

I am fairly familiar with using the set analysis to ignore selections (filters) but I haven't been able to figure out how to (or if it's possible to) do the same with regards Dimension.

Tags (2)
1 Solution

Accepted Solutions
devarasu07
Not applicable

Re: Ignore dimension in set analysis | Qlik Sense

Try like below,

Create new calculated measure like below

sum(Sales)/sum(Total Sales)

3.png

Hope this helps

4 Replies
devarasu07
Not applicable

Re: Ignore dimension in set analysis | Qlik Sense

Try like below,

Create new calculated measure like below

sum(Sales)/sum(Total Sales)

3.png

Hope this helps

sunny_talwar
Not applicable

Re: Ignore dimension in set analysis | Qlik Sense

This:

Sum(Sales)/Sum(TOTAL Sales)

Not applicable

Re: Ignore dimension in set analysis | Qlik Sense

Thanks!

Not applicable

Re: Ignore dimension in set analysis | Qlik Sense

Thanks!