Not applicable
2015-12-09
09:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
percentage vs dimension value
Hello
How do i get an expression to calculate the same result as the column 'vs France'
sales (kE) | vs France | |
France | 200 | 100,00% |
uk | 300 | 150,00% |
belgiuem | 100 | 50,00% |
Tahnks in advance for your help
463 Views
3 Replies
sunny_talwar
MVP
2015-12-09
09:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
Table:
LOAD * Inline [
Country, Sales
France, 200
UK, 300
Belgium, 100
];
Join (Table)
LOAD Sales as FranceSales
Resident Table
Where Country = 'France';
FinalTable:
LOAD Country,
Sales,
Num(Sales/FranceSales, '#.00%') as [vs France]
Resident Table;
DROP Table Table;
382 Views
sinanozdemir
Specialist III
2015-12-09
10:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
And here is the front-end solution in QlikSense:
In the expression (vs France), I typed the below:
I am also attaching qvf.
Hope this helps.
Not applicable
2015-12-09
11:40 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
sum( [sales (kE) ] / sum( { < country = { 'France' } > } [sales (kE)]
382 Views