How to only show specific values from a dimension in a chart

[Meg00]

Hi,

How do I make a dimension of time only show specific values in a bar chart (ex. my field shows 00:00,00:30, 01:00 etc.). I want the chart to only show time between 07:00 and 19:00. Best guess is to write a condition but I cant get it right.

[sujeetsingh]

go to dimention limit tab in properties there are different types of options given and you can use one required.

[Meg00]

No, theese limitations does not seem to work with the HH:MM format. Plus I want it to show values between the highest and lowest wich is not an option there.

[#4]

You can use setanalysis in expression with the dimension field

[sujeetsingh]

so nice to move on set analysis a best stategy.

[manideep78 · Accepted solution]

Hi,

See attached qvw

This might help you

Regards

Manideep