Stright and pivot table

[Anonymous]

I want all the dimensions to be displayed in a column

[MarcoWedel]

Hi,

please close your open threads that received correct answers:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

[prma7799]

for this you can use table box also.

[Anonymous]

but my requirement is like when suppose i have 4 dimensions so i should kind of get a drill down view when i click on those particular dimensions i should be displayed corresponding expressions values against it

so how i should do that,

and wht i shud use straight table,pivot table,table box

[prma7799]

for this you have to create drill down group and use it in straight table or you can use it in pivot table

and if you want values on selected dimension then use condition for expression

[neha_shirsath]

Hi,

For 4 dimensions you have differently 4 expressions? or you want when any dimension will get selected you want to see value corresponding to same?

I'm bit confuse about your question because by using pivot table you can directly also get full expanded view or you can Collapse table.

Thanks ,

Neha

[Anonymous]

or you want when any dimension will get selected you want to see value corresponding to same?

[Anonymous]

my requirement is :

fields       exp(total)      exp(avg)

sales

products

suppose i click on field sales it should be drilled to lower granularity

all the values present in field sales should appear

salesa       total               avg

salesb       total               avg

salesc       total               avg

how i should achieve this

[neha_shirsath]

Hi,

Can you please share some sample data.

Thanks,

Neha

[Anonymous]

above is the sample data