topic Re: calculated dimensions in QlikView

calculated dimensions

yogitamehta10 — Fri, 17 Nov 2017 13:34:49 GMT

i have a year dimension , I want this to work like this , year where cycle is current cycle and Last year at calculated dimensions , I want those years to show?

I have tried to give if conditions but no luck?

Re: calculated dimensions

yogitamehta10 — Fri, 17 Nov 2017 14:16:04 GMT

any response??

Re: calculated dimensions

shanky1907 — Fri, 17 Nov 2017 14:19:13 GMT

Can you please explain more?

Re: calculated dimensions

yogitamehta10 — Fri, 17 Nov 2017 15:03:23 GMT

my dimension is year that has 2016 and 2017 i have two set of data for 2017 ,
where 1st set of data is c1 and another set of data is c2 , so i have a field in my data is c that says c1 and c2 and for 2016 it says LY.

so i want to show bar graph where dimension is Year and i want to how 2016 data and 2017 data in that , that means 2017 I should point to c1 and 2016 should point to LY.

Re: calculated dimensions

VishalWaghole — Fri, 17 Nov 2017 19:27:27 GMT

Can you please upload some sample data with expected output.

Re: calculated dimensions

Anonymous — Sat, 18 Nov 2017 17:35:23 GMT

so for 2017, u have 2 sets:- c1, c2 where c1 is current dataset.

for 2016, u have only 1 set and that is LY...is this correct?

Re: calculated dimensions

yogitamehta10 — Mon, 20 Nov 2017 07:56:18 GMT

‌exactly

Re: calculated dimensions

ajaysingh29 — Mon, 20 Nov 2017 10:23:38 GMT

If you have dataset, like shown in image below :

Please check attached qvw.