topic Re: How can I see only one line? in QlikView

How can I see only one line?

markus19-85 — Wed, 13 Jun 2018 11:53:23 GMT

Hello Experts,

I need your help.

I am having a table which looks like this

but I would like to the it in this way

but also dynamically, so if I select Treaty 1 and 2 I want to see 1,2

also I do not want to use distinct, because bookings can have the same amounts for 1 Treaty

Any Ideas on that?

Regards,

Markus

Re: How can I see only one line?

sunny_talwar — Wed, 13 Jun 2018 11:56:41 GMT

This?

Re: How can I see only one line?

markus19-85 — Wed, 13 Jun 2018 12:12:30 GMT

Thanks so far, looks good for this small App, to bad it is not working in my bigger App, I try to give an example with more Data

Re: How can I see only one line?

sunny_talwar — Wed, 13 Jun 2018 12:15:01 GMT

Sure

Re: How can I see only one line?

markus19-85 — Wed, 13 Jun 2018 12:32:59 GMT

please have a look at the new upload, thanks

Re: How can I see only one line?

sunny_talwar — Wed, 13 Jun 2018 12:40:05 GMT

Check attached

Re: How can I see only one line?

markus19-85 — Wed, 13 Jun 2018 12:57:12 GMT

works so far, but you are using now distinct. what happens if I have exactly the same booking, Will I lose it?

Re: How can I see only one line?

sunny_talwar — Wed, 13 Jun 2018 13:09:54 GMT

I don't know what makes the unique combination where the duplication is present at? May be add them all as dimensions like this

Sum(Aggr(Amount, Loss, GenReUnderwritingYear, DimensionX, DimensionY...))

Re: How can I see only one line?

markus19-85 — Wed, 13 Jun 2018 13:16:04 GMT

In my Database I have an SK for every booking, but when I use that Key I can not aggregate on Loss Level, can I?

Re: How can I see only one line?

sunny_talwar — Wed, 13 Jun 2018 13:16:56 GMT

All you need this is for the expression part... dimension's don't have to change.

Re: How can I see only one line?

markus19-85 — Wed, 13 Jun 2018 13:19:44 GMT

Maybe I will do an sum(Amount) in Script first, so can add double postings already there, I think that should work.

Thanks for your help

Re: How can I see only one line?

sunny_talwar — Wed, 13 Jun 2018 13:22:19 GMT

Not a problem. Remember to close the thread as and when you get what you wanted by marking correct and helpful responses

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny