In my experience I would tell you not to simply copy tableau software but create an ergonomic and user friendly app.
For example, load your data, create all your master items (dimensions + measures).
Then add simple measures on your first tab to show global KPi's like a dashboard, add a bar chart and drag and drop dimensions and measures in it.
Add your chart to master items.
Create a second sheet now add your master visualisation freshly added chart and drag a table or pivot table on it. It will ask you if you want to convert it to a table click yes and you're done.
You now have a quick dashboard and detailed vision of your data in a few clicks.
You can do so much more, your only limit is your imagination.
Thank you for your help,
I try to create a new var1 and also chart1 by myself.
I follow all the step you did. Except my variable name = Var1 , your is Var
My chart1 is not display any thing.
Where i go wrong ?
I suppect the may be due to QSVariance extension is not correct. I try to download the latest again , it still remind the same. The extension file date is 15/8/2016.
May be the Var1 field not created. May i know howo create it ?
Hope you can advise me where i go wrong ?
Ask final (4) (1).qvf 2.4 MB