Discussion Board for collaboration related to QlikView App Development.
I want to use the quantity column from my excel table in the sql where clause !
this is the code that i tried but it didn't work :
LOAD product,QuantityFROM[MyFile](ooxml, embedded labels, table is Sheet) ;
right joinSQLselect productfrom `DB`.`table` where (Quantity - count(product)) <=0 group by product ;
Thanks for any help and attention !
One of the way to achieve based on ApplyMap concept like below.
Mapping Load product,QuantityFROM[MyFile](ooxml, embedded labels, table is Sheet) ;
Load *, where ApplyMap('MapQuantity', product, 0) - ProdCount <= 0;select product, count(product) as ProdCount from `DB`.`table` group by product ;
Hope it helps
View solution in original post
You made my day , I have never woked with mapping , I will learn about it more !
Thank you for help !
Hi mayilvahanan !
Can you check my problem here I will be greatful !