topic Re: Need to show dynamic serial number while selecting a dimension value in a straight table in App Development

Need to show dynamic serial number while selecting a dimension value in a straight table

Shikhar_Diagonal — Thu, 23 Feb 2023 07:37:26 GMT

Dear community members,

I have a requirement to show serial numbers in the Qliksense straight table dynamically based on selections. Without any selections, I need to show serial numbers based on the dimension Account Code.

S No.	Account Name	Account Code
3
1	ABC	123
1	ABC	123
1	ABC	123
2	XYZ	456
2	XYZ	456
3	PQR	789
3	PQR	789
3	PQR	789
3	PQR	789

But once, account codes are selected in the filter, it should reflect like-

S No.	Account Name	Account Code
1
1	ABC	123
1	ABC	123
1	ABC	123

And the totals should change dynamically as per the number of account codes selected.

Is this achievable? If yes, please help me with the expression that I should use.

Thanks,

Shikhar Jha

Re: Need to show dynamic serial number while selecting a dimension value in a straight table

henrikalmen — Thu, 23 Feb 2023 08:28:08 GMT

I think you need to specify what your source table(s) look like, and what you want the result to be. For example, you say "the totals should change dynamically" - totals of what? You are not showing any totals in your example.

To me it seems like if the first straight table chart is your data, then the second straight table chart in your example is what you are getting when you select "123" in the Account Code field. So I don't understand what the actual problem you are trying to solve is.

Re: Need to show dynamic serial number while selecting a dimension value in a straight table

qlik_tataelxsi — Thu, 23 Feb 2023 08:36:14 GMT

Hi Henrik,

I forgot to mention that the first row after the header row is my totals row. The totals that I want to show is the count of account codes that is selected on the filters. If nothing is selected, then it should show the count of all the account codes I have in my straight table.

S No.	Account Name	Account Code
3			Totals
1	ABC	123
1	ABC	123
1	ABC	123
2	XYZ	456
2	XYZ	456
3	PQR	789
3	PQR	789
3	PQR	789
3	PQR	789

Thanks,

Shikhar Jha

Re: Need to show dynamic serial number while selecting a dimension value in a straight table

henrikalmen — Thu, 23 Feb 2023 08:39:57 GMT

It's probably me, but I still don't understand. Could you give very specific examples? First a table with the data you have, then an example of exactly what the result should be based on that data.