Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
bobby_chowdary
New Contributor III

how to apply the filters to metric in variable level

hi Team,

Good Day

...i working around one issue but i am not able find exact solution

here my issue'

i have one metric like "mTotalSal"

and i have 2 filters  like -------abc=1      ,         cdf=0

now i need to filter out the metric values using above filters in variable level only

like

<Mtotalsal>,abc=1,cdf=0

note:A comma separated list of Boolean expression or a table expression that defines a filter


--out put:

metric is must satify the filters abc=1,cdf=0 .

and after satisfying  that filters then  i want  to sum of metric value


like in variable level  i need to create this filterd metric

Can any one suggest better way

Thanks,

Bobby

3 Replies
MVP & Luminary
MVP & Luminary

Re: how to apply the filters to metric in variable level

sum({<abc={1},cdf={0}>}mTotalSal)


talk is cheap, supply exceeds demand
bobby_chowdary
New Contributor III

Re: how to apply the filters to metric in variable level

Thanks Gysbert Wassenaar 

II have tried  the formula that you suggested. however i am not getting required result. i am supposed to get 15% but i am getting 20%. looks like filters ABC = 1& CDF = 0 are not working. when i made   filtered as needed I was getting 15%. kindly look into this.

Here  bellow you can see with out filter

baro fil2.PNG

now you can see with filter data

baro fil1.PNG

here i want to create all the above filters in variable only

please suggest me suitable matching code

Regards,

Boby

MVP & Luminary
MVP & Luminary

Re: how to apply the filters to metric in variable level

ABC is not abc. Use case sensitive field names. sum({<ABC={1},CDF={0}>}mTotalSal)


talk is cheap, supply exceeds demand