topic Re: data should dispaly in table based on selection filter in App Development

data should dispaly in table based on selection filter

whitestonek — Thu, 28 Mar 2019 11:12:41 GMT

Hi friends,

Can you please help me to work on this requirement in qliksense. Let me explain the task.

I have 3 tables like:

Table1:

DecID	Min(Sales)	Max(Sales)
1	0	0
2	55	98
3	43	46
4	56	88
5	76	93
6	47	66
7	54	65
8	66	76
9	69	78
10	39	45

Table2:

JanID	Min(Sales)	Max(Sales)
1	10	29
2	45	98
3	76	79
4	23	88
5	66	93
6	16	66
7	42	65
8	23	76
9	45	78
10	66	85

Table3:

FebID	Min(Sales)	Max(Sales)
1	9	19
2	16	98
3	25	79
4	37	88
5	24	93
6	16	66
7	51	65
8	28	76
9	29	78
10	33	85

I have above 3 table in my data model and i have filter tabs in my dashboard like DECID, JANID & FEBID. So, if i select any of filter like DECID then the data should display DECID,Min(Sales),Max(Sales) in Table in my dashboard. And then if i select FEBID then data should change and should display FEBID,Min(Sales),Max(Sales) in the same table.

I don't want to use 3 tables in my dashboards. Based on my filter tabs the data should display in single table.

Please share your ideas as soon as possible.It's very urgent to me. Thank you

Re: data should dispaly in table based on selection filter

PrashantSangle — Thu, 28 Mar 2019 11:23:26 GMT

how did you create filter tab?
can you share your exiting script?

Re: data should dispaly in table based on selection filter

whitestonek — Thu, 28 Mar 2019 11:26:29 GMT

Filter tab means, I used variable object and applied single variable to those 3 fields.Like DECID, JANID, FEBID.

Re: data should dispaly in table based on selection filter

HirisH_V7 — Thu, 28 Mar 2019 11:29:16 GMT

Main_Table:

Load 'FEBID' as DataFlag,Min(Sales) as MIN,Max(Sales) as Max
Resident FEBID_Table;

Drop table FEBID_Table;

Similarly for other two tables. Concatenate all of them.