topic Re: expression used for chart properties, dimensions in QlikView

expression used for chart properties, dimensions

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

how do I create a bar chart where the X axis is a subset of a field: ie: the field is [Day of Week}, how do I specify only "Mon" for that dimension? I'm trying to figure out what function that is, for the expression of that dimension. thanks

becki kain

Re: expression used for chart properties, dimensions

marcus_malinow — Thu, 17 Aug 2017 14:52:55 GMT

Hi Becki,

if you want ALL your measure data, but everything aligned to Monday, the week start, then create a field in your data load like so:

WeekStart(YourDateField) as WeekStart

If you want to filter your data so that only meaure data relating to Monday is shown, then you can use a set analysis expression, for example if your measure is sum of sales it would be soething like this:

sum({$<[Day of Week]={'Mon'}>} Sales)

Marcus

Re: expression used for chart properties, dimensions

Anil_Babu_Samineni — Thu, 17 Aug 2017 14:53:09 GMT

May be this?

If(Match([Day of Week], 'Mon'), [Day of Week])

And do suppress for that calc. dimension.

Re: expression used for chart properties, dimensions

becki_kain — Thu, 17 Aug 2017 14:58:19 GMT

what is suppress?

is that all Mondays or just one Monday? thanks

Re: expression used for chart properties, dimensions

becki_kain — Thu, 17 Aug 2017 14:59:59 GMT

so that would sum sales on the other axis, and just show Mondays on the first axis? thanks

Re: expression used for chart properties, dimensions

marcus_malinow — Thu, 17 Aug 2017 15:01:39 GMT

It would result in your expression only returning a value for Mondays, so the non Monday values in your dimension won't display

Re: expression used for chart properties, dimensions

vishsaggi — Thu, 17 Aug 2017 15:07:11 GMT

Can you share a screen shot with an expected output?

Re: expression used for chart properties, dimensions

becki_kain — Thu, 17 Aug 2017 16:34:31 GMT

if I had a screen shot, I'd be done 🙂

Re: expression used for chart properties, dimensions

vishsaggi — Thu, 17 Aug 2017 16:43:05 GMT

You can always draw on a paint or something or on a piece of paper and take a screen shot of your expected output to be...