Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've got an extremely basic question around creating a variable based on a field value.
Field name = Store_Group
Possible values = Group X, Group Y, Group Z
How can I create a variable to only display Store_Group where the value = Group X?
Basically I have a few charts that will be pre-filtered for report users.
Many thanks,
Dave
Not sure if you need a QV variable here, wouldn't the variable just hold 'Group X' then?
If you want to filter a chart permanently, you can either create a calculated dimension
=if(Store_Group = 'Group X', Store_Group)
and Suppress NULL on dimension tab.
Or use a set expression in all your expression aggregation functions, for example
=sum({<Store_Group = {'Group X'}>} Value)
Hi,
Instead of variable, you can use the Set Analysis to filter the data in the charts.
Anyways, in your scenario, you want variable name to be Group X or you want that variable to hold the value Group X?
Regards,
Kaushik Solanki
Not sure if you need a QV variable here, wouldn't the variable just hold 'Group X' then?
If you want to filter a chart permanently, you can either create a calculated dimension
=if(Store_Group = 'Group X', Store_Group)
and Suppress NULL on dimension tab.
Or use a set expression in all your expression aggregation functions, for example
=sum({<Store_Group = {'Group X'}>} Value)
If you just wanted your charts to show Store_Group='GroupX' then you can use set analysis in the chart expression.
sum({<Store_Group={'Group X'}>}amount ) or
if you want this to be a default value in the Store_Group filter box so that when user logs in they will see this by default and they can select another value of Store_Group from the filter box if they want. for this you can use Trigger Action (Select in Field) and you can have a Clear button created which will have the Select in Field action of Store_Group field as the Group X so that when users hit clear button the value goes back to default value.
If your variable is static(only one possible value), then you can directly store the string in the variable or use that string in place of the variable directly.If variable, then like:
vVariable='Group X'
=sum({<Store_Group = {'Group X'}>} Value)
=Count({<Store_Group = {'Group X'}>} Value)
etc
Hi Dave,
Use the GetFieldselection() function. it gives you the selection of the field value.
Declare a varaible
Ex : $(V1)=Getfieldselection(Fieldname) and then give it a layout condition $(V1)=Group X then it displays whenever the varaible having GroupX.
Thanks all, lots of useful suggestions.