data should dispaly in table based on selection filter

[whitestonek]

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

[PrashantSangle]

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

[whitestonek]

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

[HirisH_V7]

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.