Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

help with aggregation and dynamic dimensions

Hi,

in my table there are documents with different doctypes. In my diagram i want to show only the the documents in wich the documenttype is a certain one. i don`t know if i should use a dynamic dimension or a formula!? i tried to type this in my formula but it doesn`t work...

=SUM({1<VerkaufsdokumentKopf.Dokumenttyp={'2'}>} VerkaufsdokumentKopf.Grundlage)

VerkaufsdokumentKopf.Dokumenttyp is a small int field what is wrong in my expression? or what is a solution for my problem?

1 Solution

Accepted Solutions
Not applicable

help with aggregation and dynamic dimensions

It works fine on my side. Take a look at attachment.

5 Replies
Not applicable

help with aggregation and dynamic dimensions

I've never heard about such notation, but try this:


=SUM({1<Dokumenttyp={"2"}>} Grundlage)


Not applicable

help with aggregation and dynamic dimensions

thx for your replys... no i found out that my problem is a different one my concatenate doesn`t work right. i have 2 tables one with fields x y z and the other with u and v now i load them in this way

newtable:

load x as a, y as b, z as c from table1;

concatenate

load u as a ,v as lol from table2;

my problem s that in newtable there are only the values ou of table1 the values of table2 are missing

Not applicable

help with aggregation and dynamic dimensions

It works fine on my side. Take a look at attachment.

Not applicable

help with aggregation and dynamic dimensions

i had qualified the fields...=) i know i`m a idiot

Not applicable

help with aggregation and dynamic dimensions

Nobody is protected from this. And it happens with the best of us Wink