topic Re: Bar Chart in QlikView

Bar Chart

bharatkishore — Mon, 18 May 2015 05:52:43 GMT

Dear All,

I have a Name and Date Field. For these two i want to write an expression and i need to take these two fields in a single dimension. I am using a Bar Chart and need to show it as below image..PFA image for your reference...

Re: Bar Chart

amit_saini — Mon, 18 May 2015 06:01:04 GMT

Bharat ,

Try:

Name&'-' & Date_Field as Name_Date_Field and use this as dimension.

Thanks

Re: Bar Chart

bharatkishore — Mon, 18 May 2015 06:05:21 GMT

HI Amit,

Thanks for your reply...I have a name field, In that name field i have 10 sub fields and i need only 3 fields so for that i have hard coded and written as a Calculated Dimension as

=if(name='LV Information & Operation' or name='MOET HENNESSY ASIA PACIFIC/HK' or name='SINARMAS LAND/IA',name)

Now in this dimension i need to add the date field and get together(both name and date field) in the same calculated dimension. This one i need to do in the dimension itself not in the backend. Can you pls help me on this.

Thanks,

Bharat

Re: Bar Chart

amit_saini — Mon, 18 May 2015 06:10:51 GMT

Bharat,

Do one this first filter your name filed inside script side like below:

Where match(name,'LV Information & Operation','MOET HENNESSY ASIA PACIFIC/HK' ,’INARMAS LAND/IA’) ;

Next now you have name field with desired ones and later you can do what I have suggested in my first reply.

Thanks,

Re: Bar Chart

bharatkishore — Mon, 18 May 2015 06:28:28 GMT

Thanks Amit...It worked...

Regards,

Bharat

Re: Bar Chart

amit_saini — Mon, 18 May 2015 06:33:35 GMT

Good