Set up by default variable

Anonymous — Thu, 17 Apr 2014 16:17:47 GMT

Hi guys,

I have a table with 2 dimensions with conditions like below

=SubStringCount(Concat(Fields, '|'), 'Channel')

and variable where I select my field "Channel" or "Campaign"

I'd like to set up by default "Channel" field and never show 2 dimensions at the same time.

Please see my attached file.

Thanks,

Re: Set up by default variable

jerem1234 — Thu, 17 Apr 2014 16:35:43 GMT

You can remove your dimensions and add something like:

=$(=Fields)

as a calculated dimension.

This will return whatever you select and use that as dimension. However you will need to make sure that they only select 1 value at a time. You can do that by adding a listbox with your Fields field, and then check "Always one selected value". If you want Channel as default, just make sure you have that clicked when you save document.

Please find attached.

Hope this helps!

topic Re: Set up by default variable in QlikView

Set up by default variable

Re: Set up by default variable