Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Stacked barchart count expression

Hi all,

Im newbie i need to get the count like this in stacked bar chart i tried a lot but i can't find the solution.

Screenshot_2.png

I kept two dimension

1. Execution start time(X-axis)

2. Request type(Y-axis)

In expression i've written this to get the execution time.

=time([Execution Endtime]-[Execution start time])

i know i'm wrong in this expression because i want to show the count so i need to write count expression in set analysis.

by using Field distinct "Command type" .

Help me in this

Thanks in advance.

6 Replies
Anil_Babu_Samineni

What are these 0, 100 --- 900

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

I want the counts of the chart.

for example.

Meters count

Not applicable
Author

that is just an example

Anil_Babu_Samineni

For your posting i didn't find the word Meters. What was that?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

u can see the graph going in ascending order by calculating [Execution End time] and [Execution Start time]

so each id will have some Start time and end time. you can see the graph going step by step so there must be more ID's.

Anil_Babu_Samineni

May be others can help you, Because i am not fully understand on the same. BTW, Community with us they may face same issue earlier

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful