4 Replies Latest reply: Apr 4, 2016 9:32 AM by Sunny Talwar

# How to filter the data to represent in graph

Hi All,

I have just started working on QV couple of days back. Till now I am very much fine with Ok with creating basic visualization. But now I got stuck in one place

Lets Suppose

I have 4 columns in my data 1. Recovery State 2. Month 3. No. of transactions and 4. Total Amount.

Recovery State have states like Write Off, Refunded, Charge back etc.

I am trying to create a chart for Month wise transactions however I want chart to calculate the data only for Write Off state.

I can easily do it by creating list box and select Write Off in that however I dont want to create a list box instead I want to put condition by any formula in chart only that it pick data for only given state

Thanks

Dinesh

• ###### Re: How to filter the data to represent in graph

Use set analysis in your expression. Suppose your expression is Sum([Total Amount]), then change it to this:

Sum({<[Recovery State] = {'Write Off'}>} [Total Amount])

• ###### Re: How to filter the data to represent in graph

Hey Sunny,

Thanks for your reply.. Its working fine for one condition. Can I put multiple crirterias as well

Sum({<[Recovery State_Rec] = {'Written Off'}><[Fraud Type_Rec] = {'MOTO/Internet'}>} [Posted Amount_Rec])

Thanks

Dinesh

• ###### Re: How to filter the data to represent in graph

Sure, try this:

Sum({<[Recovery State_Rec] = {'Written Off'}, [Fraud Type_Rec] = {'MOTO/Internet'}>} [Posted Amount_Rec])

• ###### Re: How to filter the data to represent in graph

Great Thanks!!! I think I should also start studying scripting part of QV