topic Re: How to create a second column from a dimension value. in QlikView

How to create a second column from a dimension value.

Anonymous — Tue, 22 Dec 2015 10:01:30 GMT

Hi, I was hoping someone here would be able to help me.

I have the below data and would like the dimension data as value in one column (as the results pic), instead of 3 records.

So the first Channel in 'Channel 1', the second Channel in 'Channel 2' - this is in order by 'TV_Date'

I managed to display the first value by the below code, but need help on the following columns...

=FirstSortedValue({<TV_Date={'=aggr(min(TV_Date), FTVID)'}>}Sender, TV_Date)

Any help appreciated!

Best,

Betul

Data

Results

sunny_talwar — Tue, 22 Dec 2015 10:43:59 GMT

May be try this:

What would Channel 2 = ? since both 13th Str and History have exactly the same TV_Date?

Anonymous — Tue, 22 Dec 2015 10:52:17 GMT

Hi Sunny, Can go by alphabetical order if the TV_Date is exactly the same.

sunny_talwar — Tue, 22 Dec 2015 13:07:38 GMT

May be this in straight table

Dimension: FTVID

Expressions

Channel 1

=FirstSortedValue(Channel, TV_Date)

Channel 2

=FirstSortedValue(Channel, ((TV_Date)* 100000 + Ord(Left(Channel, 1))), 2)

Channel 3

=FirstSortedValue(Channel, ((TV_Date)* 100000 + Ord(Left(Channel, 1))), 3)

Anonymous — Tue, 22 Dec 2015 13:27:18 GMT

Hi Sunny,

That works great! Thank you so much for your help.

Betul

sunny_talwar — Tue, 22 Dec 2015 16:08:22 GMT

Not a problem