topic Re: Flow chart in QlikView

Flow chart

rathnam_qv — Mon, 14 Apr 2014 09:40:44 GMT

Hi All,

i have create a flow chart as in attached image.

but i want to call the values in the table(Display Values, see the image) into the Text Object.

can anyone help me out.

Regards,

Rathnam.

manideep78 — Mon, 14 Apr 2014 09:49:15 GMT

If that Chart is Static(If Display Label is static) you can do it using Set Analysis in each and every text object.

Write Below expressions in all the text objects that you need.

Booked:

Sum({<[Display Label]={'Booked'}>}[Display Value])

Billed:

Sum({<[Display Label]={'Billed'}>}[Display Value])

and so on.

Hope this helps.

Regards,

Manideep

rathnam_qv — Mon, 14 Apr 2014 10:25:07 GMT

Hi Manideep,

thanks for ur reply.

but i want to change my value format as $1,500,000

how to do that.

Regards,

Rathnam.

manideep78 — Mon, 14 Apr 2014 10:31:55 GMT

Try this in the Text Object for every expression:

='$ '&Num(Sum({<[Display Label]={'Booked'}>}[Display Value]),'#,###.##')

Hope this helps you.

Regards

Manideep