Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to filter a bar chart to count if a value contains a certain value

In the following example:

ABC
121
211
312
341

How would I create a bar chart that displays A, B, C on the x axis. Then counts the '1's only

Thanks in advance!

Many thanks

1 Solution

Accepted Solutions
greeshma_k
Creator III
Creator III

You could create 3 expressions with the calculation as follows

for A: count({<A = {1}>}A)

for B: count({<B= {1}>}B)

for C: count({<C = {1}>}C)

View solution in original post

6 Replies
greeshma_k
Creator III
Creator III

You could create 3 expressions with the calculation as follows

for A: count({<A = {1}>}A)

for B: count({<B= {1}>}B)

for C: count({<C = {1}>}C)

View solution in original post

Not applicable
Author

Thanks Greeshma,

Would i use A, B. C as the dimension?

greeshma_k
Creator III
Creator III

No need to add them as dimensions.

sunny_talwar

I think it might make sense to transpose the data using The Crosstable Load‌. Once you do that, you can use A, B, C (which will now be in a single field) as a dimension and Count() expression

Anil_Babu_Samineni

Yes, you can use like

ValueList('A','B','C')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
trdandamudi
Master II
Master II

See if the attached helps....