Hi Experts, I wanted to change data conditionally. In the field Loc, for the value TBA the region should be changed to ME starting from year 2016. So any data before Year 2016 should be unchanged....
Hi all, I need to calculate Average Net Price (grouped by Key A,B,C and Year) and store the result in table. The result table will be used in another calculation process. The issue is the Net P...
I have read all the discussion on SCD , they explain SCD are and some provide a solution for Type 2 and other errors using interval match function , but not for type 1 In my model i have a...
Hi Experts, What is scd? Interval match and scd are same in qlikview? if not same then how we can explain scd in interview point of view? Regards, prabhas
Hi Team, Kindly help me resolve the following query using the SCD solution Well, I have the following Inline table LOAD * INLINE [ Product, ProdName, Price, Updated &n...
Hi, I am working on Incremental load. I have come across following kind of source data. There is no 'Modification Time'. The data gets updated without any modification timestamp, how to do increme...
Hi Community, Can you help how to implement SCD (slowly changing dimension) ? I have downloaded in Community, but i am confusing with that, i.e very lengthy.. Please anyone give simple e...
