topic Re: Error on calculated dimension in QlikView

Error on calculated dimension

NavinReddy — Mon, 26 Nov 2018 12:47:09 GMT

Hello All,

Can someone help me on calculated dimension its not working for me,
i would like to disply 3Quarters info on dimention.
pleases check attached sample QVW for reference.

Thanks in Advance,
Niranjan

Re: Error on calculated dimension

sunny_talwar — Mon, 26 Nov 2018 12:25:08 GMT

Don't see any qvw file attached.

Re: Error on calculated dimension

NavinReddy — Mon, 26 Nov 2018 12:48:15 GMT

Sorry my bad, i have added could you please check.

Re: Error on calculated dimension

sunny_talwar — Mon, 26 Nov 2018 12:52:52 GMT

Try this

=if([Issue Creation Date] >= vLast3Quarter and [Issue Creation Date] <= vYourMaxDate, [Issue Creation Date])

Re: Error on calculated dimension

NavinReddy — Mon, 26 Nov 2018 13:00:00 GMT

Thank you so much for your reply, here i have a challenge i would like to show on chart Quarter wise(Q1-2018,Q2-2018,Q3-2018) like information. Any suggestions.

Re: Error on calculated dimension

sunny_talwar — Mon, 26 Nov 2018 13:06:11 GMT

What is the name of your Quarter field?

Re: Error on calculated dimension

NavinReddy — Mon, 26 Nov 2018 13:21:18 GMT

='Q' & Ceil(Month(if([Issue Creation Date]>=vLast3Quarter and [Issue Creation Date]<=vYourMaxDate,[Issue Creation Date]))/3) & '-' & year(if([Issue Creation Date]>=vLast3Quarter and [Issue Creation Date]<=vYourMaxDate,[Issue Creation Date]))

using this expression i have created the Q2-2016 format, But here i want to restrict the 3 Quarters info every time.Please suggest.

Re: Error on calculated dimension

sunny_talwar — Mon, 26 Nov 2018 13:22:45 GMT

3 Quarters info every time? What do you mean every time? Also, why don't you create a Quarter field in the script?

Re: Error on calculated dimension

NavinReddy — Mon, 26 Nov 2018 13:36:23 GMT

i have to restrict the data to show on chart 3 latest Quarters information from current Data(Q2-2018,Q3-2018 and Q4-2018).

Re: Error on calculated dimension

sunny_talwar — Mon, 26 Nov 2018 13:41:34 GMT

That does make sense, what what issue are you running into? I am not sure what the problem is?

Re: Error on calculated dimension

NavinReddy — Mon, 26 Nov 2018 15:21:35 GMT

im able to see two Quarters information on chart,for One Quarter i do not have any data reason its not visable on chart,

Could you please help me with logic, i want to display 3rd Quarter info with zero values.

Re: Error on calculated dimension

sunny_talwar — Mon, 26 Nov 2018 15:23:47 GMT

Can you post the updated qvw file to see what you have? Thanks

Re: Error on calculated dimension

NavinReddy — Mon, 26 Nov 2018 16:17:55 GMT

i have added the qvw, i am able to only one quarter info, how could i get 3 Quarters information.

Re: Error on calculated dimension

sunny_talwar — Mon, 26 Nov 2018 17:51:34 GMT

Try this

Dimension

=if([Issue Creation Date]>=vLast3Quarter and [Issue Creation Date]<=vYourMaxDate,'Q' & Ceil(Month([Issue Creation Date])/3) & '-' & Year([Issue Creation Date]))

Expression

=Count(DISTINCT{<[Issue State Name]={'New and Open','ReOpened'}, Year, Month>}[Issue ID])
=Count(DISTINCT{<[Issue State Name]={Completed}, Year, Month>}[Issue ID])
=Count(DISTINCT{<[Issue State Name]={Open}, Year, Month>}[Issue ID])

Re: Error on calculated dimension

NavinReddy — Mon, 26 Nov 2018 18:30:32 GMT

Thank you very much sir, its working