Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Key field


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

6 Replies
Highlighted
Creator III
Creator III

Hello,

Is this what you are looking for?

Highlighted
Not applicable

Would a pivot table solve your needs?

Highlighted
Creator
Creator

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

Highlighted

Pivot table will solve your needs, please go with that

Highlighted
Creator
Creator

And Another Another:

How can i Disappear the expression coluom in pivot table?

i dont need the expression

Highlighted
Creator III
Creator III

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.