Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to do a pivot chart in Qlikview to show the monthly actual cost vs budget cost of expenses. I had encountered a double count problem, the chart in Qlikview seems to have double count on the expenses. Can anyone advise me, what may have gone wrong or how should I solve this double count issue. Below is the sample of the files I had uploaded and the output I had gotten from Qlikview.
please share your xls and qvw file.
Or only qvw.
You can do it with "Use advances editor" in the answer window
Hi Prabhu,
Thank for your help, I am unable to find any options which I can upload my excel dataset or qlikview file. I can only see the upload image and link option in this forum.
Best regards,
Andy
right top corner of answer window "Use advanced editor"
and you will have an option to attach the documents
Hi,
Attach sample file, then only it is possible to figure out the issue.
Regards,
jagan.
Hi Prabhu, sorry for the late response. Please find attached. Thank you in advance.
Best regards,
Andy
Hi Sergey,
Sorry for the late reply. Please find attached.
Thank you in advance.
Best regards,
Andy
Hi,
Check your data source. You have Same records in both sheets.
If you Load only first or only second everything will be ok.
If you need some record from one sheet and some records from another
use
where not exists() - construction to exclude repeated rows in Load statement.
Hope this helps.
Andrei
Hi Andrei,
Yes, this problem occurs when I tried to load for both sheets. I am not sure on how to use "where not exists()" function, is it possible for you to show me how to use this function/expression?
Thank you.
Best regards,
Andy
Hi Andy,
PFA qvw file.
Of course better to create unique ID and use only one exists()-expression, but still
In this example you load everything from 1 Sheet and only rows which are not exists (defined by field combination) from 2. To change order just move where condition to another sheet, but note that exists should be used in the second LOAD statement.
Hope this helps.
Andrei
Hi Andrei,
Thank you so much. My issues is being solved. Really appreciate your help!
Cheers,
Andy