topic Re: Set analysis comparison in the same table in App Development

Set analysis comparison in the same table

Sush123 — Mon, 06 Dec 2021 14:56:11 GMT

Hi team,

I need help to write a set analysis with a Trend chart for the below scenario :

Need to create a bar chart to compare data between different dates and to count no of ids which were Old, New and Changed in each date. Old/New/Changed values need to be calculated on the flow if the Code is same or changed with respect to a date. Below is the example.

Id	Date	Name	Code	Flag
10	01-06-2021	A	AU	New
11	01-06-2021	B	IN	New
12	01-06-2021	C	CN	New
13	01-06-2021	D	NZ	New
12	08-06-2021	C	CN	Old
13	08-06-2021	D	AG	Changed
14	14-06-2021	E	BP	New
11	14-06-2021	B	IP	Changed

Re: Set analysis comparison in the same table

MarcoWedel — Mon, 06 Dec 2021 21:08:46 GMT

What would be the expected result given your sample data?

Re: Set analysis comparison in the same table

Sush123 — Tue, 07 Dec 2021 02:13:16 GMT

Th expected result would be a bar chart with 3 different measures ( count of ids which are old , new & Changed)with respect to each date. The comparison need to be done between the dates

Re: Set analysis comparison in the same table

Ksrinivasan — Tue, 07 Dec 2021 05:41:06 GMT

hi,

Altrnatestate method use to view the comparison of ID's which is new, old, change with different date ranges.

Re: Set analysis comparison in the same table

MarcoWedel — Tue, 07 Dec 2021 20:38:23 GMT

which values would you expect?

Re: Set analysis comparison in the same table

Sush123 — Wed, 08 Dec 2021 05:57:48 GMT

Hi @MarcoWedel , the data should be as below. Hope this is clear .

Re: Set analysis comparison in the same table

MarcoWedel — Wed, 08 Dec 2021 17:13:36 GMT

This seems to be the result of a stacked bar chart having dimensions Date and Flag as well as an expression like Count(Id).

Given the data structure you provided this seems to be standard behaviour and pretty straight forward.

Your screenshot suggests that you already have a QlikView bar chart like this that you want to implement in Qlik Sense, since you posted in the Sense forum, and that you can compare dimensions and expressions against.

What exactly is the issue you experience when creating this chart in Qlik Sense?

Re: Set analysis comparison in the same table

Sush123 — Wed, 08 Dec 2021 17:36:08 GMT

The expected values are given in the bar chart, it doesn't matter whether qlikview or qliksense . The issue is that the comparison need to be done between the dates on the fly based on IDs for which there is a change in the Code when compared. As I have already given the values for flag column in my above example,it looks easy .but I need to calculate count of Ids for which there is a change in the Code(old,new, change) with different dates.

Re: Set analysis comparison in the same table

Ksrinivasan — Thu, 09 Dec 2021 02:56:57 GMT

hi,

let me show your expected result from your data. confirm and revert.

Re: Set analysis comparison in the same table

Sush123 — Thu, 09 Dec 2021 09:02:48 GMT

Hi @Ksrinivasan , expected result is the first table . In my above data , flag column need to be calculated if there is any change in the code. But i have added it already just to understand the data.

Re: Set analysis comparison in the same table

Ksrinivasan — Thu, 09 Dec 2021 14:50:08 GMT

hi,

i did in exce formua

you can do it in QS by Range count function by replacing of CONCATENATE formula.

and use if function in result flag column use if function if 2=New, if 3= Change, if 4=old.

Re: Set analysis comparison in the same table

Sush123 — Sat, 11 Dec 2021 05:11:50 GMT

Hi @Ksrinivasan , will try this. Thanks for your help.