topic Re: Calculated dimension in QlikView

Calculated dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi lads,

[skip introduction],

I have made a graph with group dimension, (day, week, month and quarter). Things are nice and smooth, default dimension is set day. When not a single month is selected QV sums all days, (like normal BI), but what I want is when none month selected graph shows data by months not by days. Bellow is in pictures what I meant.

Variable = if(count(DISTINCT Master_calendar_Month)>1,Master_calendar_Month,Master_calendar_Day)

'Master_calendar_Month','Master_calendar_Month' and 'Master_calendar_Day' are dimensions in table. Sadly I receive '//Error in calculated dimension'

Any tips?

Tomass

Message was edited by: Tomass Kučinsks

Re: Calculated dimension

Anil_Babu_Samineni — Wed, 13 Sep 2017 15:38:16 GMT

Can you take expression and show the full expression image where you receiving error?

Re: Calculated dimension

Anonymous — Wed, 13 Sep 2017 16:02:40 GMT

When I calculate variable, I receive an error in dimensions, mentioned in a snap. When I run it in the text box, it returns '-'.

Formula I'm using = if(count(DISTINCT Master_calendar_Month)>1,Master_calendar_Month,Master_calendar_Day)

Re: Calculated dimension

Anil_Babu_Samineni — Wed, 13 Sep 2017 16:12:10 GMT

What this returns in text box?

if(Aggr(count(DISTINCT Master_calendar_Month),Master_calendar_Month)>1,Master_calendar_Month,Master_calendar_Day)

Re: Calculated dimension

Anonymous — Wed, 13 Sep 2017 16:44:28 GMT

It still evaluates it as '-', but now at least we got a working expression in dimension group at some point. Your proposed solution is evaluated as 'Master_calendar_Day', so as I understand, it returns always FALSE from if formula. I thinking about making workaround formula in expression tab.