topic Re: Chart issue in QlikView

Chart issue

NavinReddy — Fri, 11 Apr 2014 11:39:04 GMT

Dear All,

Like this format i have every month Data,Here i dont have month Field

i have data like separated every month but i want to create a BAR chart with Month dimension

I Want to create a chart like this Format

Please help me some one to solve this issue

Thanks In Advance

Niranjan

Re: Chart issue

maxgro — Fri, 11 Apr 2014 18:44:44 GMT

RESULT

SCRIPT

Source:

load * inline

[

row

Jan Jan Actual 400

Feb Jan Actual 400

Mar Jan Actual 567

Apr Jan Actual 567

May Jan Actual 567

Jun Jan Actual 400

Jul Jan Actual 788

Aug Jan Actual 400

Sep Jan Actual 456

Oct Jan Actual 345

Nov Jan Actual 400

Dec Jan Actual 400

Jan Plan 123

Feb Plan 567

Mar Plan 678

Apr Plan 567

May Plan 777

Jun Plan 888

Jul Plan 999

Aug Plan 543

Sep Plan 333

Oct Plan 345

Nov Plan 222

Dec Plan 500

];

Table:

NoConcatenate load

left(row,3) as m,

SubField(row, ' ', 3) as v,

'Plan' as type

resident Source

where wildmatch(row, '*plan*');

Concatenate (Table) load

left(row,3) as m,

mid(row, 5,3) as m2,

SubField(row, ' ', 4) as v,

'Actual' as type

resident Source

where wildmatch(row, '*actual*');

DROP Table Source;

Re: Chart issue

NavinReddy — Wed, 28 May 2014 20:35:44 GMT

Hi Masssimo,

I atteched excel dump

for that how can i create month field

please help me

Thanks in Advance

Niranjan

Re: Chart issue

Anonymous — Thu, 29 May 2014 12:39:09 GMT

i dont see excel sheet attached...

Re: Chart issue

NavinReddy — Thu, 29 May 2014 12:49:27 GMT

Sorry, please check now .

Regards,

Niranjan

Re: Re: Chart issue

Anonymous — Thu, 29 May 2014 13:22:03 GMT

Please see attached QVW file .. hope this helps...

Re: Chart issue

NavinReddy — Thu, 29 May 2014 13:29:42 GMT

Hi Vinay,

Thanks you So much

Greate Solution

Best Regards,

Niranjan

Re: Chart issue

Anonymous — Thu, 29 May 2014 13:31:08 GMT

No issues .. Glad i was able to help you