topic Calculated Dimenstion in QlikView

Calculated Dimenstion

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

Hi All,

I want to Create List Box (Month/Week),

When i Click Month ,Dimension In chart must show Data by Month ,

When i Click week ,Dimension In chart must show Data by week

Re: Calculated Dimenstion

shiveshsingh — Wed, 28 Nov 2018 06:02:22 GMT

What does MONTH signify here? Is it a dimension?

Re: Calculated Dimenstion

shitijar — Wed, 28 Nov 2018 06:38:07 GMT

Hi,

Try with the Below Expression:

if(TYPE2='MONTH',MONTH&' '&WEEK)

Shetty

Re: Calculated Dimenstion

PradeepReddy — Wed, 28 Nov 2018 07:11:21 GMT

The calculated dimension showing error, because there is no fields 'Month' or 'Week' in your data model.
First create Month & Week Fields in your script like this(check the creation_date format)...
Month(Creation_Date) as Month,
WeekName(Creation_Date) as Year_Week

now create a calculated dimension like this...
IF(TYPE2='MONTH', Month,Year_Week)