Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
markus19-85
New Contributor III

How can I see only one line?

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

1 Solution

Accepted Solutions

Re: How can I see only one line?

Check attached

Capture.PNG

11 Replies

Re: How can I see only one line?

This?

Capture.PNG

markus19-85
New Contributor III

Re: How can I see only one line?

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?

Sure

markus19-85
New Contributor III

Re: How can I see only one line?

please have a look at the new upload, thanks

Re: How can I see only one line?

Check attached

Capture.PNG

markus19-85
New Contributor III

Re: How can I see only one line?

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?

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...))

markus19-85
New Contributor III

Re: How can I see only one line?

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?

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