topic Re: Barchart with different scenarios in QLiksense in App Development

Barchart with different scenarios in QLiksense

abhijith28 — Tue, 21 Dec 2021 21:56:36 GMT

HI,

I need your help on one of my scenario.

Need to create a bar chart with one dimension and two measure

Dimension : "Name Date" & "Loan Date" (show all values in x axis)

Measure 1 : sum(Balance)

Measure 2: sum(Loan Bal)

In the app Always one Name will be preselected.

Table A: primary keys = Name

Table B: primary keys= Name & "Loan ID" & "Loan Date"

Table C : primary keys= Name & Loan ID

I am able to achieve the Barchart, the challenge is when any user selects (ex:-) "Loan ID =12" still we should able to see the chart values related to Name=A (Table1) with Measure 1: sum(Balance)

Please anyone provide me the solution.

Attached the sample app with the data.

Thanks & Regards,

Abhijith Palekar

Re: Barchart with different scenarios in QLiksense

Anil_Babu_Samineni — Thu, 13 May 2021 13:12:05 GMT

Looks like you have explained from your app where as that is different in shared app? Can you please explain more what you expect from attached application?

Re: Barchart with different scenarios in QLiksense

abhijith28 — Fri, 14 May 2021 09:55:41 GMT

@Anil_Babu_Samineni

Need to build a data model in such a way that it has to show the Bar chart as attached in the screenshot.

Re: Barchart with different scenarios in QLiksense

abhijith28 — Fri, 14 May 2021 14:23:16 GMT

@sunny_talwar @Kushal_Chawda Do you have any solution for this scenario? Please let me know if there are any.

Re: Barchart with different scenarios in QLiksense

Anil_Babu_Samineni — Sat, 22 May 2021 16:10:04 GMT

Agree, But If you explain from your app with expectation. We may look quicker?

Re: Barchart with different scenarios in QLiksense

Sammy_AK — Mon, 24 May 2021 10:55:05 GMT

hello,

for the output you needed, you need to link Table A and Table B using columns Name and Name Date from table A and name and Loan date from Table B.

many ways to execute the above logic, what i have done is derived a new column from Name Date table A and aliased to Loan date.

in your Bar chart, you just need to use Dimension as "Name Date" and 2 measures as you provided sum(Balance) and sum(Loan Balance) .

i have also attached the app for your reference, pls check in "My sheet 2"

Re: Barchart with different scenarios in QLiksense

abhijith28 — Tue, 25 May 2021 07:36:26 GMT

@Sammy_AK

The attached app doesn't have the link table. Can you please check.

Re: Barchart with different scenarios in QLiksense

Sammy_AK — Tue, 25 May 2021 08:21:52 GMT

Sorry i dont understand, what do you mean by link table ?

Re: Barchart with different scenarios in QLiksense

Sammy_AK — Tue, 25 May 2021 08:53:26 GMT

Thank you!!!