topic Re: How to achieve it in Qliksense in App Development

How to achieve it in Qliksense

wangxusq — Thu, 29 Mar 2018 03:15:24 GMT

Hi all,

I see this demo :

How to achive this ?

Thanks.

Re: How to achieve it in Qliksense

tomasz_tru — Thu, 29 Mar 2018 08:00:37 GMT

in chart properties choose 'cummulative'.

Re: How to achieve it in Qliksense

wangxusq — Thu, 29 Mar 2018 08:04:15 GMT

Hi,

I need two sides, and one is red,the other is blue.

If I just choose "cummulative",they will stay one side.

Thanks.

Re: How to achieve it in Qliksense

tomasz_tru — Thu, 29 Mar 2018 08:08:17 GMT

do you have two different dimmensions and one measure added to the chart?

Re: How to achieve it in Qliksense

wangxusq — Thu, 29 Mar 2018 08:11:58 GMT

It should be one dimension and two different measures. Not one measure and two different dimensions.

it didnot work.

Re: How to achieve it in Qliksense

petter — Thu, 29 Mar 2018 08:17:22 GMT

I guess this is pretty close to what you want to achieve then?

I have attached a Qlik Sense app where the screenshot has been taken from...

In my suggested approach there is two bar charts one for the blue and one for the red ...

Re: How to achieve it in Qliksense

tomasz_tru — Thu, 29 Mar 2018 08:34:56 GMT

So You could add minus to the second measure, and then set custom format for it: # ##0,00;# ##0,00 so the negative numbers will be showed as positive. Not an elegant solution but it should work with cummulative option.

Re: How to achieve it in Qliksense

jonathandienst — Thu, 29 Mar 2018 08:55:58 GMT

I assume that by "cummulative", you mean "stacked"?

Re: How to achieve it in Qliksense

tomasz_tru — Thu, 29 Mar 2018 08:58:40 GMT

yes (I've got PL version )

Re: How to achieve it in Qliksense

wangxusq — Thu, 29 Mar 2018 09:01:32 GMT

Thanks

Re: How to achieve it in Qliksense

wangxusq — Thu, 29 Mar 2018 09:02:43 GMT

pretty, thanks.