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: 
beginner91
Contributor III
Contributor III

Count two different words

hello all,

how can filter in 2 different groups like:

 

asd                          12

fgh                           13

qwe                         14

rtz                            15

 

iam adding asd,fgh in one group and count the numbers 12+13=25

and other group qwe,rtz counted 14+15=29

so i can filter to qwertz and it shows me 25

and asdfgh=29

 

thank you for your support

Labels (1)
  • group

4 Replies
pradosh_thakur
Master II
Master II

create another tabkle which maps it

 

field1    field2

asd        asdfgh

fgh         asdfgh

qwe       qwertz

rtz          qwertz

 

use filter2 as filter. It will work

Learning never stops.
beginner91
Contributor III
Contributor III
Author

i cant. I have something like:

x        counted number: 12

y        counted number: 13

z        counted number: 15

and want a filter for x and yz

and below i have a table when i filter x or yz

the table shows me the counted numbers. check my excel file.

thank you for your support.

beginner91
Contributor III
Contributor III
Author

?

pradosh_thakur
Master II
Master II

Hi

Your requirement is still not clear. You have to give us some proper sample data and out put. It would be easier to help out then. Please add sample data clearly, the one you have provide right now is not helping.

Thanks
Pradosh
Learning never stops.