Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to use where in Qlik view chart type

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

XYZFGHMV
ABCDECMO100.00
LMNOCMO200.00
bbbbbbbbbbTFG300.00
bvnghGBH400.00
jghtyRFT500.00

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

XYZFGHMV
ABCDECMO100.00
LMNOCMO200.00


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

Thank you very much for your help

Cheers,

Sumit

2 Replies
Not applicable

How to use where in Qlik view chart type

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
Contributor III

How to use where in Qlik view chart type

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).

XYZFGHMV
ABCDECMO100.00
LMNOCMO

Hope it will help you

Regards

Neetu Singh