Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a flat data table that purely shows the results of any changes made using Qlik filters. i have now added some variable buttons to remove the need for so many filters. this changes my charts as this is all based on counts and sums i.e.if(vType = 1, Sum(POLICYCOUNT),
if(vType=2, sum({<RTM={'GCS Stand Alone'}>}POLICYCOUNT),
If(vType=3, sum({<RTM={'SME Stand Alone'}>}POLICYCOUNT),
if(vType=4,Sum({<RTM={'SME Add-on','GCS Add-on'}>}POLICYCOUNT)))))
however how do i restrict my table to only desplay data based on a set criteria. This only shows columns with NO measures. What i want to do is select a variable button (button 2) and for it to restrict the data where column "RTM" = "GCS Stand Alone", button 2 "RTM" = "SME Stand Alone" etc. It seems like it should be obvious but im going round in circles. appears that you can only do it using an agr which i dont need to do. is it not as simple as =if(vType=1, RTM = {'GCS Stand Alone'},if(vType=2,RTM={'SME Stand Alone'})) ???
Thanks