topic Re: Filter data set in table in QlikView

Filter data set in table

Anonymous — Sun, 10 May 2015 10:54:14 GMT

Hi,

I have a data model, with 2 types of ads: free and paid.

in the data model, I have a report thta shows all ads,

and a second report that shows revenues, clearly I need to show only the paid ads,

but what is the best way of doing this?

needs:

I don't want the user to use the report wrongly and show both types of ads

I want to present it in a straight table

arulsettu — Sun, 10 May 2015 11:14:28 GMT

hi,

try this

sum({<addtype={'paid'}>}amount)

sunny_talwar — Sun, 10 May 2015 11:20:07 GMT

Not sure what you requirement is? Do you want your revenue table to just show information related to paid ads only???

Anonymous — Sun, 10 May 2015 11:58:23 GMT

Exactly

sunny_talwar — Sun, 10 May 2015 12:01:57 GMT

There is two ways I can think of doing this:

One would be a calculated dimension where you can use a if statement

If(ads = 'paid', yourDimension) and then you can suppress the null.

Alternatively, you can use set analysis in all your expressions:

{<ads = {'paid'}>}

I hope this helps.

Best,

Sunny