topic Re: Expression Help in QlikView

Expression Help

sona_sa — Fri, 13 Jul 2018 10:45:03 GMT

Hi All,

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

Data is displaying –

Country	Location	Violation Status
Canada	San Diego	No 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

Country	Location	Violation Status
Canada	San Diego	No 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

sunny_talwar — Fri, 13 Jul 2018 11:33:40 GMT

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

sona_sa — Fri, 13 Jul 2018 11:41:01 GMT

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 — Fri, 13 Jul 2018 11:43:30 GMT

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

sona_sa — Fri, 13 Jul 2018 12:16:24 GMT

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.