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

Announcements
Join us in NYC Sept 4th 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