topic Limit data in QlikView

Limit data

venkey2847 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have year field, it has values like 2014,2015, 2016,2017, 2019,2025

But I want display 2015,2016,2017 data only.

How can I achive this dynamically....

Please help me out this issue...

Thanks

Venkey

Re: Limit data

prma7799 — Fri, 21 Apr 2017 05:30:07 GMT

Hi Venkey,

Use Where condition in your script.

where match(Year, 2015,2016,2017) ;

Re: Limit data

Anil_Babu_Samineni — Fri, 21 Apr 2017 05:36:58 GMT

Or this

Set Var = 2015,2016,2017;

LOAD * Inline [

Year1

2014

2015

2016

2017

2019

2025] Where Match(Year1, $(Var));

Re: Limit data

qlikview979 — Fri, 21 Apr 2017 06:23:11 GMT

Hi Try like this

Dynamically it will change.

Re: Limit data

venkey2847 — Mon, 24 Apr 2017 13:45:46 GMT

In front end I need to display and I should have all the data for another report...

I shouldn't do filtering the data..

In table box I need to display those three years of data...

Please help me out this issue..

Thanks

Venkey

Re: Limit data

Anil_Babu_Samineni — Mon, 24 Apr 2017 14:45:38 GMT

First of all, When you create table box it will consider as 3 years data

Second thing, In set analysis you need to like below

Sum({<Year = {'2015','2016','2017'}>} Sales)

Re: Limit data

snehamahaveer — Mon, 24 Apr 2017 14:57:57 GMT

Hi Venky,

There are different ways of achieving this:

1. If you are using a table box - then I suggest you create an inline table in script that has years required. Use this column as dimension.

2. In a chart, use calculated dimension if you are displaying year. Eg if(Match(Year,'2015','2016','2017'), Year) and suppress null values.

3. In a chart, in the expression use set analysis to display the years required. eg. Sum({<Year = {'2015','2016','2017'}>}Sales)

Hope this helps,

Re: Limit data

deepakkrish — Mon, 24 Apr 2017 15:32:42 GMT

Hi Kumar

There's no option for a calculated dimension in a Table Box. Why don't you use

List box instead of Table box.