Transformation

[deepakqlikview_123]

Hello Team,

please find attachment,

After making trasformations I am able to convert Rows to column in qlikview.

But can you please suggest how to hide null colums like F1,F2,F5,F26 in qlikview.

Thanks in advance.

Thanks

[deepakqlikview_123]

Thanks Jagan/anand,

After making changes

Final:

NoConcatenate

LOAD * Resident Tmp  Where Len(Year) > 0;

DROP Table Tmp;

It is not showing null value for year.

Thanks,

Deepak

[its_anandrjs]

Thanks Deepak,

Close the thread with select appropriate answer.

Regards

Anand

[deepakqlikview_123]

Hi Anand,

can you please suggest on showing above excel data in chart format which chart shall we use also suggest

If I wnat to see data Year,Month,Day I will use drill qown group on x axis.

On Y axis I want below details.

Can you please suggest how to proceed for this.

CDMS AUDIT LOG Size GB

        CDMS WSS CONTENT Size GB

        CDMSLive DATABASE Size GB

        LOG size CDMS AUDIT LOG Size GB

        LOG size CDMS WSS CONTENT Size GB

        LOG size CDMSLive Database Size GB

        Application Server-II 122 (465 GB)

        Application Server-I 123 (465 GB)

        Database Server 124  (C: 1.08 TB, 😧 464 GB, E: 464 GB)

        Database Mirror Server 125 (C: 1.08 TB, 😧 464 GB, E: 464 GB)

Thanks.

[its_anandrjs]

For this you can create the straight table and create the drill down group as add by fields

Year, Month, Day

-------------------------

And in the straight table add all the fields with drill down group that is

        Year-Month-Day //Drill Group      

        CDMS AUDIT LOG Size GB

        CDMS WSS CONTENT Size GB

        CDMSLive DATABASE Size GB

        LOG size CDMS AUDIT LOG Size GB

        LOG size CDMS WSS CONTENT Size GB

        LOG size CDMSLive Database Size GB

        Application Server-II 122 (465 GB)

        Application Server-I 123 (465 GB)

        Database Server 124  (C: 1.08 TB, 😧 464 GB, E: 464 GB)

        Database Mirror Server 125 (C: 1.08 TB, 😧 464 GB, E: 464 GB)

And in expression add 1

[jagan]

Hi Deepak,

If you use where condition it will filter some records, check whether any records are missing.

Where Len(Year) > 0

Regards,

Jagan.

[deepakqlikview_123]

Hi Anand,

As per requirement I need to show trends in series.

If we can use line chart how to show the above details in it.

Thanks,

[deepakqlikview_123]

Hi Jagan,

I fI want to show sum of  CDMS WSS CONTENT Size GB in line chart with year dimension.

Can you please suggest  how formatting should be.What will be expression.

Thanks