topic Re: Flipping between views in QlikView

Flipping between views

Thu, 28 Jul 2016 22:30:15 GMT

I have a table with duplicates. I would like to build something where if the users select "all", Qlikview will show them all the data and if they select "unique", it shows them only the unique data. How would I go about building something like this?

Re: Flipping between views

johnw — Thu, 28 Jul 2016 23:23:56 GMT

Maybe like this.

LEFT JOIN ([Main Table])
LOAD
[Key]
,if(count([Key])=1,'Y','N') as [Unique?]
RESIDENT [Main Table]
GROUP BY [Key]
;

[Views]:
LOAD * INLINE [
View, Unique?
All,Y
All,N
Unique,Y
];

Re: Flipping between views

rwunderlich — Thu, 28 Jul 2016 23:28:21 GMT

To show all rows in a TableBox or Straight Table, you must have some underlying unique value column you can use as a Dimension in the table. So toggling between showing all rows and consolidating duplicates is a matter of toggling the inclusion of the unique column on/off.

Take a look at this sample for an example:

Qlikview Cookbook: Tutorial - About Column Visibility http://qlikviewcookbook.com/recipes/download-info/tutorial-about-column-visibility/

Specifically, the Pivot table on the "Conditional (Dynamic) Columns" sheet where the unique OrderId is toggled on and off.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com