Hi
I'm trying to get the top 3 values without doing aggregation in the expression. My top 3 deals value should be based on base_value. In script i have created the sorting order by desc based on base value. This logic was working fine when i don't have same values but not working when i have same values. Below is issue i'm facing with the logic when i use only in expression as i should not apply aggregation in the expression. Below is the sample data. Please can someone let me know how to achieve the expected output.
Expression for base value: only({<company={'ABC'},sort={"<4"}>}base_value)
The above expression repeats for the other measures.
| Month |
date |
base_value |
product name |
value 1 |
value 2 |
value 3 |
| Aug |
2018-08-02 |
40 |
samsung |
10 |
0.0008 |
6 |
| Aug |
2018-08-13 |
30 |
Nokia |
8 |
0.0006 |
5 |
| Aug |
2018-08-10 |
20 |
apple |
5 |
-0.0005 |
4 |
| Aug |
2018-08-10 |
20 |
apple |
5 |
0.0001 |
4 |
| |
|
|
|
|
|
|
| Qlik Output |
|
|
|
|
|
|
| Aug |
2018-08-02 |
40 |
samsung |
10 |
0.0008 |
6 |
| Aug |
2018-08-13 |
30 |
Nokia |
8 |
0.0006 |
5 |
| Aug |
2018-08-10 |
20 |
apple |
5 |
- |
- |
| |
|
|
|
|
|
|
| Expected output |
|
|
|
|
|
|
| Aug |
2018-08-02 |
40 |
samsung |
10 |
0.0008 |
6 |
| Aug |
2018-08-13 |
30 |
Nokia |
8 |
0.0006 |
5 |
| Aug |
2018-08-10 |
20 |
apple |
5 |
0.0001 |
4 |
