Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2014-11-13 12:12 AM

match function in qlikview

hi all ,

i have years from 2000 to 2015 .Now i am trying to print years from 2005-2012 .How to do it with match() rather than hard coding  the years from 2005-2012 .

Thanks

43,398 Views
12 Replies
bvssudhakar
Creator III
Creator III
‎2018-03-22 05:10 AM

In response to sujeetsingh

Hi,

I have a urgent requirement, here i attached one qvw file in that filter i have 6 set of filters

Now i want to show the AND condition for those filter sets (data which will satisfy all the 5 filters applied.) which means the data which matches all the filters in 5 sets should only display in the result chart / table.



Can you guys help me out from this, It is an urgent Requirement


Kindly help me



Thank you  in advance




Regards

Sudhakar

CollectFilters_294299.qvw
658 Views
0 Likes
shiveshsingh
Master
Master
‎2018-03-22 06:08 AM

In response to bvssudhakar

Can you elaborate a bit, like what do you want to see in your chart? only data related to 5 filters?

658 Views
0 Likes
bvssudhakar
Creator III
Creator III
‎2018-03-22 07:23 AM

In response to shiveshsingh

No, Matching values of those filters like

       

OrderIDOrder dateCategory NameProduct NameCustomerSales PersonQuantity
24222/16/2012Baby ClothesAino ShoesHalle KölnBob Park41
24222/16/2012Baby ClothesDeuce ShirtHalle KölnBob Park11
46651/21/2013Baby ClothesAino ShoesLa Moda d'il FuturiRicardo Gucci61
46651/21/2013Baby ClothesDeuce ShirtLa Moda d'il FuturiRicardo Gucci12
6811/12/2011Baby ClothesAino ShoesGrunewaldFrank Roll22
6841/12/2011Baby ClothesAino ShoesBond LtdRob Carsson21
7141/30/2011Baby ClothesAino ShoesBolerosMike Ashkenaz25
11166/20/2011Baby ClothesAino ShoesArt et FashionLennart Skoglund14
11316/25/2011Baby ClothesAino ShoesDe la VitaLennart Skoglund8
624112/10/2013Baby ClothesDeuce ShirtLe Sais de RiónMichelle Tyson150
624712/13/2013Baby ClothesDeuce ShirtThe Corner StoreRob Carsson153
627612/20/2013Baby ClothesDeuce ShirtGluderstedtBob Park19
63401/2/2014Baby ClothesDeuce ShirtBolerosMike Ashkenaz105
63411/3/2014Baby ClothesDeuce ShirtRode & ViteLennart Skoglund6
63571/7/2014Baby ClothesDeuce ShirtToo Hot 4URob Carsson155
63691/12/2014Baby ClothesDeuce ShirtDe la VitaLennart Skoglund11
64332/3/2014Baby ClothesDeuce ShirtLa Legion MercenaireMichelle Tyson147

This is my table

if i select Baby clothes, Aino Shoes, 2012 for filter 1 and for filter 2 Baby clothes, Deuce Shirt, 2013 then the out put will come like this


       

24222/16/2012Baby ClothesAino ShoesHalle KölnBob Park41
24222/16/2012Baby ClothesDeuce ShirtHalle KölnBob Park11
46651/21/2013Baby ClothesAino ShoesLa Moda d'il FuturiRicardo Gucci61
46651/21/2013Baby ClothesDeuce ShirtLa Moda d'il FuturiRicardo Gucci12

Help me out from this.... it's a very urgent requirement 

Already i attached the qvw file also

658 Views
0 Likes