topic Re: Multiple Condition in Set Analysis in QlikView

Multiple Condition in Set Analysis

Mon, 25 Aug 2014 14:47:31 GMT

Dear all,

I have a set of data similar to the following one.

I want to show the data above in a straight table. I have 2 variable, vFromDate and vToDate to control the range of creation date that will be shown in the table. Also, I want to disregard the effect current selection of Folder ID on the straight table. Finally, I want to show data with owner=o or viewer=v or administrator=a only.

I tried the following expression but it is not working as what i expected

sum({<[Folder ID]=,[Creation Date]={'>=$(=Date(vFromDate, 'YYYY-MM-DD'))<=$(=Date(vToDate, 'YYYY-MM-DD'))'}>*<Adminsitrator={'A'}+ Owner={'O'}+Viewer={'V'}>}[Size])

Would you please help? Thanks a lot.

Re: Multiple Condition in Set Analysis

jaimeaguilar — Mon, 25 Aug 2014 14:53:08 GMT

Hi,

I think the second part of your expression is what giving you trouble:

sum({<[Folder ID]=,[Creation Date]={'>=$(=Date(vFromDate, 'YYYY-MM-DD'))<=$(=Date(vToDate, 'YYYY-MM-DD'))'}>*<Adminsitrator={'A'}+ Owner={'O'}+Viewer={'V'}>}[Size])

Try rewriting it as follows:

sum({<[Folder ID]=,[Creation Date]={'>=$(=Date(vFromDate, 'YYYY-MM-DD'))<=$(=Date(vToDate, 'YYYY-MM-DD'))'}>*<Adminsitrator={'A'}, Owner={'O'}, Viewer={'V'}>}[Size])

regards

Re: Multiple Condition in Set Analysis

Tue, 26 Aug 2014 01:56:01 GMT

Thanks for your advice.I tried it but it is still not working.

Re: Multiple Condition in Set Analysis

jagan — Tue, 26 Aug 2014 03:02:05 GMT

Hi,

Can you attach sample file?

Regards,

Jagan.