Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
whitestonek
Contributor II
Contributor II

data should dispaly in table based on selection filter

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:

DecIDMin(Sales)Max(Sales)
100
25598
34346
45688
57693
64766
75465
86676
96978
103945

Table2:

JanIDMin(Sales)Max(Sales)
11029
24598
37679
42388
56693
61666
74265
82376
94578
106685

Table3:

FebIDMin(Sales)Max(Sales)
1919
21698
32579
43788
52493
61666
75165
82876
92978
103385

 

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

 

 

3 Replies
PrashantSangle

how did you create filter tab?
can you share your exiting script?
Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
whitestonek
Contributor II
Contributor II
Author

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

HirisH_V7
Master
Master

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.

HirisH
“Aspire to Inspire before we Expire!”