topic Re: Problem in straight table and need expression in list box in QlikView

Problem in straight table and need expression in list box

geam1988 — Sun, 16 Sep 2018 15:21:52 GMT

Hi,

I have straight table report.

Order Number, Product and Delivery Number are dimensions.

Aggr(Sum (Quantity), [Order Number], Product) is expressions.

Expressions supposed to be at the end but in my report, it is in the middle. Why?

I have list box for Delivery Number. Delivery number 20 has no quantity. I do not want to see 20 in the list box that’s why I used following expression. =If(Aggr(Sum (Quantity), [Order Number], Product)>=1 , [Delivery Number])(it is working properly)

If I select all delivery number than I can see which quantity has delivery number. I am also interested to see the quantity where I have no delivery number. What should I do?

Re: Problem in straight table and need expression in list box

jonathandienst — Sun, 16 Sep 2018 15:46:38 GMT

>>Expressions supposed to be at the end but in my report, it is in the middle. Why?

Most likely because you dragged the expression to the right which placed it in the middle of the dimensions. Just drag it back again.

>>I do not want to see 20 in the list box

Use this expression:

=Aggr(If(Sum (Quantity) > =1 , [Delivery Number]), [Order Number], Product)

>>I am also interested to see the quantity where I have no delivery number.

In a textbox, use:

Sum(If(IsNull([Delivery Number]), Quantity))

Re: Problem in straight table and need expression in list box

geam1988 — Sun, 16 Sep 2018 16:47:12 GMT

Thanks Jonathan.

Now i have report like this.

If i select all delivery number, i am getting report like this. delivery number with quantity. this is also ok.

>>I am also interested to see the quantity where I have no delivery number.

(Actually i mean, i want to see the report like this). i want to select something so that i get the quantity where i have no delivery number.

Order Number	Product	Delivery Number	Aggr(Sum (Quantity), [Order Number], Product)
102	KK	-	1
104	PP	-	1

Re: Problem in straight table and need expression in list box

sujeetsingh — Sun, 16 Sep 2018 22:47:45 GMT

Just tune the expression to handle such scenario please.

Re: Problem in straight table and need expression in list box

geam1988 — Mon, 17 Sep 2018 06:33:14 GMT

Hallo Sujeet,

I did not understand what do you mean. Can you please say that in Expression or Can you please explain it little bit more.

Thanks