How to use where in Qlik view chart type

[#1]

Hello Experts,

I am new to Qlikview and trying to find my way to a problem.

Here is the problem

Following is the set of data

XYZ	FGH	MV
ABCDE	CMO	100.00
LMNO	CMO	200.00
bbbbbbbbbb	TFG	300.00
bvngh	GBH	400.00
jghty	RFT	500.00

I want to bring all the records back which have column FGH as 'CMO' in straight table type. Following is the resultant dataset

XYZ	FGH	MV
ABCDE	CMO	100.00
LMNO	CMO	200.00

Please let me know if this possible. If yes then how.

Thank you very much for your help

Cheers,

Sumit

[#2]

HI,

I`m assuming that XYZ and FGH are dimensions and MV Numeric part of your table.

Take XYZ and FGH in straight table as dimension and add below code as expression.

=sum({<FGH = {"CMO"}>} MV)

this may help you.

- Sridhar

[neetu_singh]

Hi,

you can also use "if" statement as in your expression :

sum(if(FGH = 'CMO',MV)).

and if you want in dimension, then click on add calculated dimension and write : = if(FGH = 'CMO',FGH)

By using this dimension in straight table it only shows CMO as mention below. when you use in dimension then your expression will be sum(MV).

XYZ	FGH	MV
ABCDE	CMO	100.00
LMNO	CMO

Hope it will help you

Regards

Neetu Singh