Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Expression Help

Hi All,

  1. I have a scenario like -> In Sheet 1 à I select project à Project à XMM7560, Year à 2018, Month à Jun

Data is displaying –

   

CountryLocationViolation Status
CanadaSan DiegoNo Violation

Now I go to Sheet 2, Where I have triggered on sheet active – Clear All

So all selction goes on.

There is 1 Table box and 1 Pivot there, where in Table I want to see all data in Table box and In Pivot I want to see

   

CountryLocationViolation Status
CanadaSan DiegoNo Violation

But It is displaying all data for Pivot

Please find the attached qvw for reference. Please share some idea How I can do the same.

Regards,

Kumar

4 Replies
sunny_talwar

TEST2 tab doesn't have any pivot table... all I see if 3 list boxes and a table box...

sona_sa
Creator II
Creator II
Author

Yes Sunny,

In table box I want all data in Table box but I need that Pivot Table whatever the data is displaying in Test 1 sheet.

Please find the attached file.

sunny_talwar

May be use alternate state and put your table box in an alternate state and plus remove the trigger to clear all

sona_sa
Creator II
Creator II
Author

Hi Sunny,

Sorry I need only Canada data in table box. Without any selection. In case if there is no any list box is not available.

If u will check the data - One is normal country and another one Country_metadb,

So I am selecting in test1 it should to effect in same here for country_metadb.

Hope u got my point.