topic Re: How to display Nested columns in Straight table? in QlikView

How to display Nested columns in Straight table?

Mon, 10 Nov 2014 05:23:38 GMT

Hi All,

I need to display nested columns in My Straight table ? With example i need? Help me.

Re: How to display Nested columns in Straight table?

aveeeeeee7en — Mon, 10 Nov 2014 05:47:04 GMT

Use Pivot Table

In Straight Table you can' do Subgrouping.

You can only achieve below result in Straight Table. See Snapshot:

You have to individual Field Expressions for each State. Like this:

Dimension = Date

Expression=

1) Sum({<Country={'USA'}>}Amount)

1) Sum({<Country={'IND'}>}Amount)

1) Sum({<Country={'JPN'}>}Amount)

1) Sum({<Country={'UK'}>}Amount)

Hope that helps.

Regards

Av7eN

Re: How to display Nested columns in Straight table?

jagan — Mon, 10 Nov 2014 05:50:17 GMT

Hi,

Grouping is not possible in Straight Table, if you have static number of values Country then you can write separate expressions refer above post for this.

Why you are not looking for Pivot table, if you able to provide the sample will try this in Pivot table.

Regards,

Jagan.

Re: How to display Nested columns in Straight table?

Mon, 10 Nov 2014 05:53:02 GMT

Hi Av7en,

Can u explain more abot this.

Re: How to display Nested columns in Straight table?

Mon, 10 Nov 2014 06:09:55 GMT

Let me know your Email ID Jagan?

Re: Re: How to display Nested columns in Straight table?

aveeeeeee7en — Mon, 10 Nov 2014 06:34:03 GMT

See the Attachments.

Regards

Av7eN