topic Re: Dyanmic Chart values in QlikView

Dyanmic Chart values

Thu, 29 Oct 2015 09:17:14 GMT

Need to create one more column with value of ageing

over 150 has value ,so create one more column with value as over 150

like I have a chart with list of value on Ageing (i.e. total, Not Due ,0-30, 61-90)

customer No ,customer Name, chain, total, Not Due ,0-30, 61-90

1 ,A ,MM ,0 ,11 ,0 ,0

2 ,B ,UU ,0 ,0 ,0 ,669

3 ,C ,XX ,0 ,0 ,48, 0

then output table should include one more column Description with value of ageing having data

customer No ,customer Name, chain, total, Not Due ,0-30, 61-90, Description

1 ,A ,MM ,0 ,11 ,0 ,0, Not Due

2 ,B ,UU ,0 ,0 ,0 ,669 ,61-90

3 ,C ,XX ,0 ,0 ,48, 0 ,0-30

tamilarasu — Thu, 29 Oct 2015 09:41:03 GMT

Check the attachment (Is this you want!!) and let me know.

Kushal_Chawda — Thu, 29 Oct 2015 09:48:51 GMT

you can create the expression something like below

if( Expression of Not due >0, 'Not Due',

if( Expression of 0-31 >0, '0-31',

if( Expression of 31-60 >0, '31-60'

. )))

Anonymous — Thu, 29 Oct 2015 10:40:25 GMT

I would suggest go with cross table load you will get Description column values.

Thanks

BKC

Fri, 30 Oct 2015 04:23:34 GMT

dear Khush,

Not Due ,0-31 ,31-60 and the value of field ageing with cross table structure

sujeetsingh — Fri, 30 Oct 2015 04:35:50 GMT

Not able to get what you want?