topic Re: Re: Regarding enabling sub topics in QlikView

Regarding enabling sub topics

Tue, 25 Mar 2014 10:41:16 GMT

Hi everyone,

Here is an issue.

Suppose I want to display "Total " and in the next column "10"

Such that clicking on will display additional rows... for eg.

Total 10

a 2

b 5

c 3

what can I use??

Again I do not want additional Columns.. I need additional rows

Re: Regarding enabling sub topics

Tue, 25 Mar 2014 10:48:30 GMT

I think this can be achieved by playing around in pivot table, not sure thought. Can you share a sample app?

Re: Regarding enabling sub topics

tresB — Tue, 25 Mar 2014 10:54:32 GMT

Have you tried hierarchy?

Re: Regarding enabling sub topics

Tue, 25 Mar 2014 11:09:06 GMT

actually i want some thing like this:

1 a 10

2 b 15

3 c 30

4 d 5

so when i press the sign beside 'c' the output is:

1 a 10

2 b 15

3 c 30

i 15

ii 5

iii 10

4 d 5

Re: Re: Regarding enabling sub topics

Peter_Cammaert — Tue, 25 Mar 2014 11:29:54 GMT

Plain pivot table does this by itself:

I probably missed something?

Yes I did. Should have read your post in its entirety. Below is the same pivot, now with Style->Indent activated. If you only keep the first dimension label, the pivot may appear to have only one column.

The values aren't properly aligned. But that can be fixed.

Is this an acceptable compromise?

Re: Regarding enabling sub topics

sudeepkm — Tue, 25 Mar 2014 11:45:56 GMT

You may use a drill group with second and third fields and present them in a Pivot table.

Whenever user selects a value the next level should show. Please take a look at the attachment.