topic Re: select particular data in QlikView

select particular data

Tue, 28 Jul 2015 03:32:06 GMT

Hello,

I have a table as following,

CompanyName	Date	Stock	StockFlag
AAA	2015-07-15	25	-
AAA	2015-07-16	30	Y
AAA	2015-07-16	28	Y
BBB	2015-07-15	16	-
BBB	2015-07-16	35	Y
BBB	2015-07-16	40	Y

I want to only sumary the amount of the stock with condition 'stockflag=Y' by company name and date, my expression is like '

if(StockFlag='Y',sum({$<CompanyName>}Stock),'NA'), is it correct ?

If use 'set analysis' statement, how about the expression ?

Expecting result is like:

CompanyName	Date	Stock
AAA	2015-07-16	58
BBB	2015-07-16	75

Thanks

Jessica

robert_mika — Tue, 28 Jul 2015 03:45:17 GMT

sum({<StockFlag={'Y'}>} Stock)

svenkita — Tue, 28 Jul 2015 03:51:41 GMT

While creating the Straight Table or Pivot Table

have the

Dimension as CompanyName and Date

and the expression as

Sum({<StockFlag={'Y'}>} Stock)

SatyaPaleti — Tue, 28 Jul 2015 04:01:22 GMT

Hi Jessica,

Take CompanyName and Date as Dimensions

in Expression :- Sum({<StockFlag={'Y'}>} Stock)

Thank you,

Satya

Tue, 28 Jul 2015 04:47:49 GMT

Hi Jessica lv,

Take Dimensions: Company Name and Date

Expression: Sum({<StockFlag={'Y'}>}Stock) .

Regards,

Kalyan.