How to filter the data to represent in graph

[#1]

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

[sunny_talwar · Accepted solution]

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

[#3]

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

[#4]

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

[sunny_talwar]

Sure, try this:

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