topic Re: Displaying identical column in Straight Table in QlikView

Displaying identical column in Straight Table

Tue, 22 Dec 2015 13:16:59 GMT

Dear QV Experts,

One straight table, CustomerName, ItemNumber are dimensions.

Sum(Sales) is Expression.

I have two rows,

CustomerName ItemNumber Sum(Sales)

ABC 1234 1000

BCD 1234 2000

But it is displaying as

ItemNumber Sum(Sales)

1234 1000

1234 2000

Though it is different customers but i am not displaying customers can we able to show the Identical Numbers in one row

ItemNumber Sum(Sales)

1234 3000

The qvw attached.

Please suggest me.

Thanks in Advance

Re: Displaying identical column in Straight Table

sunny_talwar — Tue, 22 Dec 2015 13:21:02 GMT

Remove CustomerName from the dimension and you will get the desired result:

Re: Displaying identical column in Straight Table

kristof_j — Tue, 22 Dec 2015 13:21:33 GMT

What do you want?

You can delete CustomerName from the dimensions instead of hiding it. Then you should get 1 row.

Re: Displaying identical column in Straight Table

sunny_talwar — Tue, 22 Dec 2015 13:24:31 GMT

Alternatively, you can use this expression if keeping the CustomerName dimension is a requirement:

Sum(Aggr(Sum(Sales), ItemNumber))

Re: Displaying identical column in Straight Table

Tue, 22 Dec 2015 17:46:34 GMT

Thanks Sunny. It works for me now. Thanks a lot.

Re: Displaying identical column in Straight Table

sunny_talwar — Tue, 22 Dec 2015 17:47:31 GMT

Awesome

Re: Displaying identical column in Straight Table

Wed, 23 Dec 2015 19:09:43 GMT

Dear QV Experts,

Displaying the Sum of Value for Unique Item Number, we used AGGR function.

Sum(Aggr(Sum(Sales), ItemNumber))

Now i have a expression, Trend, [A minichart where i have to Display the Sales Value with DateValue.(which shows lowervalue & higher value in Red & Blue color respectively)

But now in the item number[Second Chart], i have only one row which is the Aggr Sum of the Sales Value.

Can you please suggest me how to display the Trend chart [MiniChart] to display like the first chart [Distributor]

Thanks in Advance.

Sasi

Re: Displaying identical column in Straight Table

sunny_talwar — Wed, 23 Dec 2015 19:13:31 GMT

Don't have the sample to play around with it, but try this:

Min(Aggr(Sum(Sales), ItemNumber, Distributor)) and

Max(Aggr(Sum(Sales), ItemNumber, Distributor))

It would be helpful if you can share a sample.

Re: Displaying identical column in Straight Table

Wed, 23 Dec 2015 19:25:00 GMT

Hello Sunny,

Thanks a lot.

Please find enclosed, the sample file.

The output of the second chart should be in single line only but the Trend should look like the first chart.

Thanks,

Sasi

Re: Displaying identical column in Straight Table

sunny_talwar — Wed, 23 Dec 2015 19:34:49 GMT

This?

Used ItemNumber and a calculated dimension (=If(Aggr(Sum(Sales), ItemNumber) > 0, CustomerName)) and select 'Suppress When Value Is Null' for the calculated dimension.

Expressions stay the same:

1) Sum(Aggr(Sum(Sales), ItemNumber))

2) Sum(Sales)

Re: Displaying identical column in Straight Table

Wed, 23 Dec 2015 20:09:13 GMT

Hi Sunny,

It works for me now. Awesome. Thanks a lot.

Re: Displaying identical column in Straight Table

sunny_talwar — Wed, 23 Dec 2015 20:11:57 GMT