topic Re: How to filter the data to represent in graph in QlikView

How to filter the data to represent in graph

Mon, 04 Apr 2016 12:35:35 GMT

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

sunny_talwar — Mon, 04 Apr 2016 12:38:36 GMT

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

Mon, 04 Apr 2016 12:46:27 GMT

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

Re: How to filter the data to represent in graph

Mon, 04 Apr 2016 13:15:25 GMT

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

sunny_talwar — Mon, 04 Apr 2016 13:32:11 GMT

Sure, try this:

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