Clear data

[Anonymous]

Hi,

I use Input button, which should clear data. It should be like a filter. If I input 30, I want to see results for N_Month more than 30.

avg({ $< Client*=>, N_Month='$(Variable2)'}[MyField])

Thanks,

[CELAMBARASAN · Accepted solution]

Try this

Is Variable2 is used in input box?if so use

avg({ $< Client*=>, N_Month={">$(=Variable2)"}>}[MyField])

[Anonymous]

It didn't work.

I have a chart, where I show all  student (TOTAL) by month and one of them student.

I want use condition, where I can select min result to show into avg.

Thanks,

[Anonymous]

I used =sum({ $<N_Month={">$(=Variable2)"}>}[TASK_COMPLETION]) in text box, I got the result.

But in chart, I have dimension MYEAR, It didn't show anything.

[Anonymous]

It works, but not perfect

[Anonymous]

Thanks, I changed a bit condition

[swarup_malli]

In this expression

avg({ $< Client*=>, N_Month={">$(=Variable2)"}>}[MyField])

what is the significance of       *=

why is star being used before =

Thnx

SM

[Anonymous]

You can use without *, it was from previous version of QV.

[swarup_malli]

Ok, thank you Vovan