Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HELLO FRIENDS, i have 2 files, RAW & SMACKDOWN. I need a favour.
could you help me sync this 2 files together? I think its using QVD,but i'm not really sure how to go about doing this.
Basically
1)Qlikview file called RAW and another Qlikview file called SMACKDOWN.
2)Sync 2 files together.
3)Must open in 1 QLikview file.
4)RAW & SMACKDOWN in a list box as options.
5)When click RAW, the details from the RAW data file should be opened.
6)When click SMACKDOWN, the details from the SMACKDOWN data file should be opened.
Can this be done??
THANK YOU! 😄
Hey guys, this is the second file called SMACKDOWN!
Recap, what i need is,
Raw & Smackdown. Sync 2 files together. Open in another file, and that file should have both data.
can this be done ?
I checked and most of the table are the same.
So, create a single script and use concatenate to merge the two tables. Use a flag to differenciate between RAW and SMACKDown.
Use this flag as a condition to hide or show your sheets.
For example:
RAW:
LOAD 'RAW' as SOURCE,
Brands as BRAND,
[Product Description]
as DESC,
[Price(SGD)]
as PRICE,
Discount
asDISCOUNT1
FROM
C:\QPRICE\SAMPLES\somepractice1.xlsx
(
ooxml, embedded labels, table isSheet1);
In sheet properties, show sheet condition, include =if(SOURCE='RAW',1,0)
Let me know if you need more details.