topic Merge Cells Handle in QlikView

Merge Cells Handle

NavinReddy — Tue, 15 Sep 2015 06:15:48 GMT

Hello Experts,

Good Morning

Do you guys have any idea how to handle Excel merge cells

i have Month(Merge Cell) under this i have two values (Add,Delete )

this scenario i don't know how to link with these days to my calendar,i just want to know how to map calendar

can some to help me to find the solution

Thanks In Advance

Niranjan

Re: Merge Cells Handle

sunny_talwar — Tue, 15 Sep 2015 06:18:58 GMT

Can you share a sample with the expected output?

Re: Merge Cells Handle

Tue, 15 Sep 2015 06:26:59 GMT

Hi,

Can you share the data.

Re: Merge Cells Handle

NavinReddy — Tue, 15 Sep 2015 06:28:06 GMT

Hi Sunny,

If user select 8/15/2015, how he can ADD and DELETE the data

in calendar if can i select the 8/15/2015 date, i just want to see only selected month data

And here i want to perform two thinks ADD the data and DELETE the data

any suggestions

Best Regards,

Niranjan

Re: Merge Cells Handle

NavinReddy — Tue, 15 Sep 2015 06:38:53 GMT

Hi Harshitha,

I can provide you sample data how it looks like

Next time one month it will add to the database

So we are going to do User only he can select the month and he can add or delete his own data

Let me know if you need more info

Thanks,

Niranjan

Re: Merge Cells Handle

jonathandienst — Tue, 15 Sep 2015 07:07:58 GMT

Is your problem how to handle the first row merged cells in your excel source?

You can use "Enable Transformation Step" option:

Select the Rotate tab and click the Transpose button

Now select the fill tab, click Fill and in the Fill Cells dialog, select the row number (now a column number), click Cell Condition... and then OK.

This will fill the column.

Select Rotate tab again and click Transpose again to return the original orientation.

This adds a filter term to the FROM file qualifier

filters(Transpose(),Replace(1, top, StrCnd(null)),Transpose())

For example

FROM

(ooxml, embedded labels, table is Sheet1, filters(Transpose(),Replace(1, top, StrCnd(null)),Transpose()));

Re: Merge Cells Handle

jonathandienst — Tue, 15 Sep 2015 07:09:01 GMT

Use this load script for the attached file:

Stage:

Crosstable(Name, Value)

LOAD *

FROM

(ooxml, embedded labels, table is Sheet1, filters(Transpose(),Replace(1, top, StrCnd(null)),Transpose()));

Final:

NoConcatenate

LOAD ID,

Left(Name, 2) As Name,

Value

Resident Stage;

DROP Table Stage;

Re: Merge Cells Handle

NavinReddy — Tue, 15 Sep 2015 08:39:56 GMT

Hi Jonathan,

Thanks for your reply i will try to use this technique Many thanks

Thanks,

Niranjan