topic Re: Key field in QlikView

Key field

amiroh81 — Mon, 09 Feb 2015 12:37:54 GMT

Hello
I wish to cutting data according to a key field Can I do this?

for example:

i have those fields,

A B C

-------------------------------------------

1 ZZZ XXX

1 EEE EEE

2 333 222

3 444 333

3 ZZZ ZZZ

3 RRR RRR

I Wont to Display the data like (A field will be the key field):

A B C

-------------------------------------------

1 ZZZ XXX

1 EEE EEE

________________________

2 333 222

________________________

3 444 333

3 ZZZ ZZZ

3 RRR RRR

thanks in advanced

Amir

Re: Key field

reshmakala — Mon, 09 Feb 2015 14:48:51 GMT

Hello,

Is this what you are looking for?

Re: Key field

Mon, 09 Feb 2015 14:54:50 GMT

Would a pivot table solve your needs?

Re: Key field

amiroh81 — Tue, 10 Feb 2015 06:40:26 GMT

Hi,

That helpful.

At first I thought that but bothered me the sign of but i figured out how to download the mark.
Is it possible to BOLD the line between the groups?

Thanks in advanced

Re: Key field

avinashelite — Tue, 10 Feb 2015 06:42:55 GMT

Pivot table will solve your needs, please go with that

Re: Key field

amiroh81 — Tue, 10 Feb 2015 07:00:31 GMT

And Another Another:

How can i Disappear the expression coluom in pivot table?

i dont need the expression

Re: Key field

reshmakala — Tue, 10 Feb 2015 14:54:15 GMT

In my example, Go to the properties tab -> Expressions

Check the conditional option and put in 1=2 or any condition that is not true. This will hide the expression column in the pivot table. The result will be:

Hope that helps.