Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count Distinct with condition in Text Object?

Hi everyone,

I am still quite new to QlikView and could need some help.

I would like to track certain changes made in SAP with QlikView.

The overall tracking is not a problem: I simply use a text object and =Count(Distinct (Änderungsbelegnr)). By counting the individual IDs that are created when a change is made, I now know how many changes were made in total.

Now, I would like to distinguish between changes concerning general data and bank data.The Information needed is stored in a different field ("SAP Tabelle"). See screenshot below.

In the second screenshot I marked two of the required values to display changes made in bank details.

I already thought of an if-statements, maybe in combination with a match-Statement, but I cannot make it work.

So what I need in the end is a table box that looks like the following (but displays the corresponding values):

The remaining values in the field "SAP Tabelle" will be needed to create the general data figure.

I hope I explained my problem well enough. Any suggestions are very welcome and appreciated.

Thank you in advance.

Regards,

Daniela

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi

Is it like this ?

assuming  "SAP Tabelle" is a field...

count (Distinct { <[SAP Tabelle]={"LFBK","LFB1"}  > }  Änderungsbelegnr )

sorry , if i misunderstood ..your requirement....

View solution in original post

4 Replies
Anonymous
Not applicable
Author

Hi

Is it like this ?

assuming  "SAP Tabelle" is a field...

count (Distinct { <[SAP Tabelle]={"LFBK","LFB1"}  > }  Änderungsbelegnr )

sorry , if i misunderstood ..your requirement....

avinashelite

try like this

Count(Distinct ({<[SAP Tabelle]={'LFB1','LFBK'}>}Änderungsbelegnr))

Not applicable
Author

This works perfectly. Thank you so much!

And sorry for the confusion. I know it is a bit weird to name a field "Tabelle"

One additional question that just came to my mind. If I don't want to have the distinct count but the regular one, how would this look like? The below won't work.

Count({ < [SAP Tabelle ]={'LFBK','LFB1'} > }  Änderungsbelegnr)

Regards,

Daniela

Not applicable
Author

Thanks a lot. The round brackets after "Distinct" are not necessary.