topic Display one row item in QlikView

Display one row item

Wed, 25 Nov 2020 16:16:04 GMT

I have a table that displays the same item for different months. I want only one row item to be displayed summing up each of the months value. But when i use the month filter pane it should just give me the selected months value.

example: name impressions clicks ln market period

495 trade 230 16 03/12

495 trade 130 12 04/13- 04/30

495 trade 140 5 05/23

I want just one row item to be displayed in my table that is 495 trade and the sum of the months. and later when i select the filter pane lets say march it should return 495 trade 230 16 03/12

How can this be achieved?

Thanks

Re: Display one row item

vishsaggi — Mon, 18 Sep 2017 20:28:10 GMT

When you say sum of months? You mean what sum? impressions sum or Clicks sum?

Try like

Using straight table

Add dimensions: name

ln market period -> For this dimensions check enable conditional and write the condition like

= GetSelectionCount(lnmarketPeriod) > 0

Expr1: Sum(impressions)

Expr2: Sum(clicks)

Re: Display one row item

dinuwanbr — Tue, 19 Sep 2017 06:34:04 GMT

Hi Tiwari,

Can you upload a sample for better understanding?

Rgds,

Tharindu