Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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