topic Re: Stacked barchart count expression in QlikView

Stacked barchart count expression

Wed, 25 Nov 2020 16:16:04 GMT

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.

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.

Anil_Babu_Samineni — Thu, 08 Dec 2016 01:14:50 GMT

What are these 0, 100 --- 900

Thu, 08 Dec 2016 02:01:09 GMT

I want the counts of the chart.

for example.

Meters count

Thu, 08 Dec 2016 02:01:39 GMT

that is just an example

Anil_Babu_Samineni — Thu, 08 Dec 2016 02:03:20 GMT

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

Thu, 08 Dec 2016 02:19:35 GMT

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 — Thu, 08 Dec 2016 02:22:38 GMT

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