topic Re: How to do this? in QlikView

How to do this?

gauthamchilled — Tue, 14 Jul 2015 08:16:53 GMT

Country States Rate

India Delhi 5%

India Mumbai 10%

India Kerala 3%

To something like below in a pivot or straight table

India Rate

Delhi 5%

Mumbai 10%

Kerala 3%

Re: How to do this?

MK_QSL — Tue, 14 Jul 2015 08:20:41 GMT

What is the Logic behind this? Please explain...

Otherwise you can take States as Dimension and use label as Country or India

Re: How to do this?

datanibbler — Tue, 14 Jul 2015 08:20:45 GMT

Hi,

it would be helpful if you could elaborate a bit on what is this "this" which you're trying to achieve. That set of figures you have in your post could be interpreted in many ways ...

HTH

Re: How to do this?

alexandros17 — Tue, 14 Jul 2015 08:25:09 GMT

Take a look at this

Re: How to do this?

gauthamchilled — Tue, 14 Jul 2015 08:59:54 GMT

Just wanted to change the header grouping from left side to top. Don't know how to say..its like

Country States Rate

India Delhi 5%

India Mumbai 10%

India Kerala 3%

Australia Sydney 8%

Australia Canberra 4%

Australia Perth 2%

I want something like the grouping below either in straight or pivot table.

Country Rate

India

Delhi 5%

Mumbai 10%

Kerala 3%

Australia

Sydney 8%

Canberra 4%

Perth 2%

Re: How to do this?

MK_QSL — Tue, 14 Jul 2015 09:08:22 GMT

Create a Pivot Table

Dimension

Country

State

Expression whatever you want!

Re: How to do this?

struniger — Tue, 14 Jul 2015 09:09:27 GMT

How about removing the country dimension, then naming the States dimension something like =only(Country)

Now when you select a Country from a list box you'll get your format.

Re: How to do this?

ankitbisht01 — Tue, 14 Jul 2015 09:19:35 GMT

If i am getting your requirements right it is like that , you want to see all the state under country India ?

if this is the req. it is very to easy to make in pivot table.

PFA

Regards,

Ankit

Re: How to do this?

Tue, 14 Jul 2015 09:21:35 GMT

Use pivot with Charts

Re: How to do this?

gauthamchilled — Tue, 14 Jul 2015 09:33:28 GMT

Anikit,

the one which you did is not my requirement...check my query above. yours is just normal pivot table with existing field name.

Re: How to do this?

jagan — Tue, 14 Jul 2015 09:39:32 GMT

Hi,

It is not possible in Qlikview, the alternative solution for this layout you can use Pivot Table

Dimensions : Country, State

Expression: Only(Rate)

Please find attached file, at most this is possible.

Hope this helps you.

Regards,

Jagan.

Re: How to do this?

gauthamchilled — Tue, 14 Jul 2015 09:47:00 GMT

Jagan,

Country and State are two columns in your pivot. What I want is under India, same column want to bring the cities or states. how can I do that?

Re: How to do this?

ankitbisht01 — Tue, 14 Jul 2015 09:57:22 GMT

you should use hierarchy's then make Hierarchy's

Re: How to do this?

gauthamchilled — Tue, 14 Jul 2015 10:01:59 GMT

ankit,

how to use hierarchy's before making Hierarchy's?

Re: How to do this?

jagan — Tue, 14 Jul 2015 10:07:34 GMT

Hi Gautham,

This is not possible.

Regards,

Jagan.

Re: How to do this?

ankitbisht01 — Tue, 14 Jul 2015 10:11:15 GMT

mistakenly wrote that i mean to say check if Hierarchy's can solve your problem

Re: How to do this?

qlikmsg4u — Tue, 14 Jul 2015 10:21:31 GMT

Hi Gautham,

It may not be the correct solution but I give it a try.

Re: How to do this?

jagan — Tue, 14 Jul 2015 10:33:39 GMT

Hi,

Please find attached file, hope it helps you.

Regards,

Jagan.

Re: How to do this?

avinashelite — Tue, 14 Jul 2015 10:40:25 GMT

Hi Gautham,

Pivot table is the closest option you can use , getting the data with the same column is not possible

Re: How to do this?

alexandros17 — Tue, 14 Jul 2015 10:43:16 GMT

This is my example