topic Re: Dimension with set analysis in QlikView

Dimension with set analysis

ziabobaz — Thu, 12 Jul 2018 15:35:34 GMT

Hi,

I have two dimensions:

I want to build a table with Source as dimension.

However, I want to show only those Fileds, where Channel=Paid.

something like

={<Channel={'Paid'}>} source

I know I can put a Channel filter on the dashboard > choose 'Paid' as the table will show me the numbers.

My aim is to limit the clicks so the table shows 'Paid' Sources right away.

Thank you!

Gleb.

vishsaggi — Thu, 12 Jul 2018 15:46:18 GMT

Try this as your dimension for Source

= Aggr(Only({< Channel = {'paid'} >} Source), Source, Channel)

groveliam — Thu, 12 Jul 2018 17:36:17 GMT

If the above doesn't work, you can try to just use a simple if statement. I do something similar in one of my tables. It would look like:

=if(Channel = 'Paid', Source)

Let me know if it does not work out, good luck!

ziabobaz — Fri, 13 Jul 2018 07:44:10 GMT

Both of them work, thank you!