topic Re: Stright and pivot table in QlikView

Stright and pivot table

Anonymous — Tue, 18 Jul 2017 16:29:59 GMT

I want all the dimensions to be displayed in a column

Re: Stright and pivot table

MarcoWedel — Wed, 19 Jul 2017 00:04:24 GMT

Hi,

please close your open threads that received correct answers:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

Re: Stright and pivot table

prma7799 — Wed, 19 Jul 2017 04:42:18 GMT

for this you can use table box also.

Re: Stright and pivot table

Anonymous — Wed, 19 Jul 2017 06:19:20 GMT

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

Re: Stright and pivot table

prma7799 — Wed, 19 Jul 2017 06:25:04 GMT

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

Re: Stright and pivot table

neha_shirsath — Wed, 19 Jul 2017 07:19:40 GMT

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

Re: Stright and pivot table

Anonymous — Wed, 19 Jul 2017 07:49:43 GMT

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

Re: Stright and pivot table

Anonymous — Wed, 19 Jul 2017 09:37:40 GMT

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

Re: Stright and pivot table

neha_shirsath — Wed, 19 Jul 2017 11:59:07 GMT

Hi,

Can you please share some sample data.

Thanks,

Neha

Re: Stright and pivot table

Anonymous — Wed, 19 Jul 2017 12:06:38 GMT

above is the sample data

Re: Stright and pivot table

Anonymous — Wed, 19 Jul 2017 13:47:25 GMT

kindly help for the above query

Re: Stright and pivot table

Anonymous — Fri, 21 Jul 2017 05:08:29 GMT

kindly help how to get a drill down view

Re: Stright and pivot table

neha_shirsath — Fri, 21 Jul 2017 05:50:03 GMT

Hi,

Your question is not clear yet to me, because sales field is your KPI and Product is Dimension so how can you be put sales on click? it has particular value w.r.t product correct?

Here you are using sales & product both as dimension,is it like that?

Thanks,

Neha

Re: Stright and pivot table

Frank_Hartmann — Fri, 21 Jul 2017 06:10:27 GMT

please "kindly "close your open threads that received correct answers:

Qlik Community Tip: Marking Replies as Correct or Helpful

I guess a lot of people around here wont help/answer as long as you behave in this way!

Re: Stright and pivot table

Anonymous — Fri, 21 Jul 2017 06:45:07 GMT

yes