topic Re: expression in QlikView

expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: expression

Anonymous — Tue, 23 Oct 2018 19:53:50 GMT

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.

Re: expression

bhaveshp90 — Tue, 23 Oct 2018 20:28:44 GMT

Check the attached qvw.

Re: expression

andrei_delta — Wed, 24 Oct 2018 07:25:11 GMT

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

Re: expression

Mark_Little — Wed, 24 Oct 2018 07:50:28 GMT

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

Re: expression

Anonymous — Wed, 24 Oct 2018 16:39:59 GMT

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

Re: expression

Anil_Babu_Samineni — Thu, 25 Oct 2018 07:02:12 GMT

PFA, If that helps

Re: expression

Anonymous — Thu, 25 Oct 2018 14:59:38 GMT

Hi Anil

As you see, the Aggr function get a wrong answer, the correct answer should be 65.

Re: expression

Anonymous — Thu, 25 Oct 2018 15:17:29 GMT

Thanks

I have got the answer with Aggr function.

Re: expression

Anil_Babu_Samineni — Thu, 25 Oct 2018 15:18:58 GMT

My Bad, Check now?

Re: expression

Anil_Babu_Samineni — Thu, 25 Oct 2018 15:19:51 GMT

Awesome, Please close this Thread flag as "Correct Answer"