Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this table:
Order | With | Q | Z | Repeat |
970170 | 397 | 4,132 | 466.73 | 12.00 |
970170 | 400 | 138.5 | 466.73 | 12.00 |
970170 | 405 | 453 | 466.73 | 12.00 |
and my qv file is attached, my question is, why when remove With dimension the result of last column is changed?
Awesome, Please close this Thread flag as "Correct Answer"
I do not know why I remove the With dimension , the result has been changed? Actually, I would like to reach the answer without using With as a dimension.
Check the attached qvw.
Hi,
Because you have the same date for all your 3 rows and the formulas are aggregated to date...so the result is only one row.
hope it helps,
Andrei
Hi,
As suggested it is because you have exactly the same data in all three rows. Qlik will only show a new line when data is different. You will see if you add a expression Count(Order) it will show 3 when you don't have the With dimension on, proving there is three lines.
Mark
Thanks a lot, it is somehow what I want, But it is possible to only show the total, I mean, I would like to change the below straight table
Order | Expression |
970170 | 57 |
970170 | 2 |
970170 | 6 |
65 |
To this table:
Order | Expression |
970170 | 65 |
PFA, If that helps
Hi Anil
As you see, the Aggr function get a wrong answer, the correct answer should be 65.
Thanks
I have got the answer with Aggr function.
My Bad, Check now?